Shortcuts

Display Modify Cell Style dialog box

Pinterest LinkedIn Tumblr
Display Modify Cell Style dialog box 1

Alt + ; shortcut key helps select the visible cells only. We can use this before we copy so that we pick only the visible cells and not any hidden rows or columns.
This would help in cases like where only the subtotals of data are displayed and the data is hidden and we need to use only the sub-totals.

Display Modify Cell Style dialog box 2

Related Posts

Write A Comment