How to hide cell selection in excel

Try Microsoft Edge A fast and secure browser that's designed for Windows 10 No thanks Get started. Suppose you have a worksheet that contains confidential information, such as employee salaries, that you do not want a co-worker who stops by your desk to see.

Or perhaps you multiply the values in a range of cells by the value in another cell that you do not want to be visible on the worksheet. By applying a custom number format, you can hide the values of those cells on the worksheet. Although cells with hidden values appear blank on the worksheet, their values remain displayed in the formula bar where you can work with them.

Click the first cell in the range, and then drag to the last cell, or hold down SHIFT while you press the arrow keys to extend the selection. You can also select the first cell in the range, and then press F8 to extend the selection by using the arrow keys.

To stop extending the selection, press F8 again.

Click the first cell in the range, and then hold down SHIFT while you click the last cell in the range. You can scroll to make the last cell visible. Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges.

You cannot cancel the selection of a cell or range of cells in a nonadjacent selection without canceling the entire selection. Drag across the row or column headings. Or select the first row or column; then hold down SHIFT while you select the last row or column. Click the column or row heading of the first row or column in your selection; then hold down CTRL while you click the column or row headings of other rows or columns that you want to add to the selection.

Hold down SHIFT while you click the last cell that you want to include in the new selection. The rectangular range between the active cell and the cell that you click becomes the new selection. To cancel a selection of cells, click any cell on the worksheet. On the Home tab, click the Dialog Box Launcher next to Number. The selected cells will appear blank on the worksheet, but a value appears in the formula bar when you click one of the cells.

How to Hide a Cell’s Contents in Excel? [Quick Tip] | omenejomy.web.fc2.com - Learn Microsoft Excel Online

In the Category box, click General to apply the default number format, or click the date, time, or number format that you want. Search Office help No results.

Hide or display cell values Applies To: Was this information helpful? How can we improve it?

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

How to Hide Sheets, Cells, Columns, and Formulas in Excel

Learn Windows Office Skype Outlook OneDrive MSN. Devices Microsoft Surface Xbox PC and laptops Microsoft Lumia Microsoft Band Microsoft HoloLens.

Downloads Download Center Windows downloads Windows 10 apps Office apps Microsoft Lumia apps Internet Explorer. Values Diversity and inclusion Accessibility Microsoft in education Microsoft philanthropies Corporate social responsibility Privacy at Microsoft.

Company Careers About Microsoft Company news Investors Research Site map. Click the Select All button. Click the row or column heading.