When you select a single cell, the cell is highlighted with a colored border. When you select a range of cells, the range is highlighted with a colored border and all cells except the active cell are highlighted with a colored fill. System settings determine the highlight color, but if selected cells are not clearly visible, you can change to a color that provides more contrast.
Important: Changing the system settings will affect the appearance of all selections in all applications. For example, the new highlight color will indicate selected text in Microsoft Word or folders that are open in the Finder.
This shortcut will select only visible cells in the current selection. This means hidden cells in the current selection will not be selected. Watch our video tip on this shortcut for a demonstrartion. In Mac Excel 2016, you can use the same shortcut as Windows, Alt. Select the cells. Right-click and select Format Cells. In the Format Cells dialog box, select the checkbox next to Shrink to fit. Data in the cell reduces to fit the column width. Jul 16, 2014 Use this simple keyboard shortcut to select the visible cells only when copying and pasting a range with hidden rows or columns or filtered data. Windows: Alt+; Mac: Cmd+Shift+Z.
On the Apple menu, click System Preferences.
Click General.
In the Highlight color box, click the color that you want.
Note: You must close and then reopen Excel to see the new highlight color.
On the Apple menu, click System Preferences.
Under Personal, click Appearance. Mac 8 emulator.
On the Highlight color pop-up menu, click the color that you want.
Note: You must close and then reopen Excel to see the new highlight color.
Formatting text or numbers can make them appear more visible especially when you have a large worksheet. Changing default formats includes things like changing the font color, style, size, text alignment in a cell, or apply formatting effects. This article shows you how you can apply different formats and also undo them.
If you want text or numbers in a cell to appear bold, italic, or have a single or double underline, select the cell and on the Home tab, pick the format you want:
Click Home and:
For a different font style, click the arrow next to the default font Calibri and pick the style you want.
To increase or decrease the font size, click the arrow next to the default size 11 and pick another text size.
To change the font color, click Font Color and pick a color.
To add a background color, click Fill Color next to Font Color.
To apply strikethrough, superscript, or subscript formatting, click the Dialog Box Launcher, and select an option under Effects.
You can position the text within a cell so that it is centered, aligned left or right. If it’s a long line of text, you can apply Wrap Text so that all the text is visible.
Select the text that you want to align, and on the Home tab, pick the alignment option you want.
If you change your mind after applying any formatting, to undo it, select the text, and on the Home tab, click Clear > Clear Formats.