Menu
Note: Cell borders that you apply appear on printed pages.If you do not use cell borders but want worksheet gridline borders to be visible on printed pages, you can display the gridlines. For more information, see Print with or without cell gridlines. 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. Apr 03, 2017 This outline means that only the visible cells are selected. Go ahead and use the Ctrl+C and Ctrl+V shortcuts to copy and paste the content of the visible cells. Select Only Visible Cells In Excel – Menu. Select the cells you want to copy. Again, don’t worry if the selected range includes hidden columns and/or rows. Nov 29, 2017 Hello, Does anyone know if we can set the Copy and Paste Function to default into copying and pasting only the visible cells? I'm using Excel 2016 in Windows 10. I've been doing the Alt +; and then copying it way but when copying, I never want the hidden cells anyway. So I'm wondering if.
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.
Newer versionsOffice 2011
Microsoft Excel 2016 Book
- 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.
- 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.