How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Print Excel Sheets With Gridlines: Steps and TipsYes. In Excel for Microsoft 365 on Windows, select the worksheet, go to Page Layout > Sheet Options > Gridlines, and check…
- Can You Protect Cells in Excel? A Practical GuideYes. In Excel for Microsoft 365 on Windows, mark the cells you want to protect as locked, then choose Review > Protect…
- Can You Password Protect an Excel File? How It WorksYes. In Excel for Microsoft 365 on Windows, open the workbook and select File > Info > Protect Workbook > Encrypt with…
- Can You Password Protect an Excel Spreadsheet?Yes. In Excel for Microsoft 365 on Windows, you can require a password to open a workbook by choosing File > Info…
- Can You Print an Excel Sheet? Settings, Pages, and TipsYes. In Excel for Microsoft 365 on Windows, open File > Print, check the preview, choose a printer and settings, then select…
- Can You Merge Excel Spreadsheets? Methods That WorkYes. In Microsoft Excel for Microsoft 365 on Windows, you can combine spreadsheets by copying worksheets, appending rows with Power Query, joining…
- Can You Merge Two Excel Spreadsheets? Methods ExplainedYes. In Excel for Microsoft 365 on Windows, you can merge two spreadsheets by copying worksheets, stacking rows with Power Query, or…
- Password Protect a Tab in Excel: What Actually WorksYes. In Excel for Microsoft 365 on Windows, select the worksheet tab, go to Review > Protect Sheet, choose what users may…
- Can You Make Lowercase Uppercase in Excel? Here’s HowYes. In Excel for Microsoft 365 on Windows, use the UPPER function to turn lowercase text into uppercase, for example =UPPER(A2) when…
- Can You Lock One Tab in Excel? Sheet Protection ExplainedYes. In Excel for Microsoft 365 on Windows, you can protect one worksheet tab without protecting the others: open that sheet, choose…
- Can You Lock Zoom in Excel? Limits and WorkaroundsNo. Microsoft Excel for Microsoft 365 on Windows has no built-in setting that locks worksheet zoom or prevents someone from changing it.…
- Can You Link Two Excel Spreadsheets Together?Yes. In Excel for Microsoft 365, you can link one workbook to another with an external-reference formula, so a cell in the…
- Can You Lock Cells in Excel? How Cell Protection WorksYes. In Excel for Microsoft 365 on Windows, you can lock selected cells by marking them as locked and then choosing Review…
- Highlight Text in Excel: What You Can and Can’t DoYes—you can format only selected characters inside an Excel cell, including changing their font color, applying bold, or adding italics. In Excel…
- Can You Import Excel Into Planner? Steps and LimitsYes—Microsoft Planner can create tasks from an Excel workbook when the Planner experience available to your account includes an Excel import option.…
- Excel Cell Indent: How to Add and Adjust Text IndentsYes, you can indent content in an Excel cell. In Excel for Microsoft 365 on Windows, select the cell or range, then…
- Can You Hide Tabs in Excel? Sheets, Steps, and LimitsYes. In Excel for Microsoft 365 on Windows, right-click a worksheet tab and choose Hide to conceal that sheet, or turn off…
- Can You Hide Cells in Excel? Methods and LimitsYou cannot hide one individual cell in Excel with a dedicated hide-cell command. You can hide its entire row or column, make…
- Can You Hide Columns in Excel? How to Do ItYes. In Excel for Microsoft 365 on Windows, select one or more column headers, right-click, and choose Hide; you can also use…
- Can You Export Smartsheet to Excel? Steps and LimitsYes. Open the Smartsheet sheet or report you want to export, then choose File > Export > Export to Microsoft Excel; Smartsheet…
- Can You Group Excel Tabs? Steps, Uses, and Risks ExplainedYes. In Excel for Microsoft 365 on Windows, hold Ctrl and click the worksheet tabs you want to group, or select a…
- Can You Encrypt an Excel File? Protect It SecurelyYes. In Excel for Microsoft 365 on Windows, open the workbook and choose File > Info > Protect Workbook > Encrypt with…
- Can You Encrypt an Excel Spreadsheet? Here’s What WorksYes. In Excel for Microsoft 365 on Windows, open the workbook and choose File > Info > Protect Workbook > Encrypt with…
- Can You Export Asana to Excel? CSV Steps, Limits, and Tips GuideYes. Asana can export a project as a CSV file, and Microsoft Excel can open that file; if you want a native…
- Can You Duplicate an Excel File? Methods and TipsYes. In Excel for Microsoft 365 on Windows, use File > Save As to save the open workbook under a new name,…
- Can You Duplicate an Excel Sheet? Yes, Here’s HowYes. In Excel for Microsoft 365 on Windows, right-click the worksheet tab, choose Move or Copy, select where to place the copy,…
- Can You Convert Notepad to Excel? A Practical GuideYes. You can bring a Notepad text file into Excel for Microsoft 365 on Windows with Data > From Text/CSV, or paste…
- Can You Auto Capitalize in Excel? Methods That WorkYes. In Excel for Microsoft 365 on Windows, AutoCorrect can capitalize the first letter of a sentence as you type; for names,…
- Can You Capitalize Words in Excel? Methods That WorkYes. In Excel for Microsoft 365 on Windows, use PROPER to capitalize the first letter of each word, UPPER to make text…
- Can You Align Shapes in Excel? A Practical Guide to LayoutYes. In Excel for Microsoft 365 on Windows, select two or more shapes, then choose Shape Format > Align and pick an…