It will show you that W is the hotkey or “keyboard accelerator” to get to the View tab. As shown in the video at the top of the post, Excel will guide you the rest of the way with screen tips. When you’ve already frozen rows/columns, Alt-W-F-F will UNfreeze instead of Freeze (the Freeze Panes option is replaced with Unfreeze Panes):Īs long as you can remember that Freeze Panes is on the Vie w tab, you don’t need to memorize the whole shortcut.
#FREEZE HEADERS IN EXCEL 2016 FULL#
Therefore, the full shortcuts are as follows (they are all easy left-handers):įreeze Panes Based On Cursor Location: Alt-W-F-Fįreeze Top Row Only (regardless of cursor location): Alt-W-F-Rįreeze First Column Only (regardless of cursor location): Alt-W-F-C
F to freeze both rows and columns - based on where your cursor is (this will freeze rows and columns to the right and to the left of your cursor).The Freeze Panes shortcut is an easy left-hander:Īlt-W-F brings up the following Freeze Panes drop-down: No more paranoia that you’re looking at the wrong row - because now you can see the header all of the time. No more need to scroll back up to remember what column you’re looking at. Then when you scroll down, those rows remain visible. With Freeze Panes, you freeze one or more rows at the top of your screen. When you scroll up and down on your worksheet, do you lose sight of your headers? Do you fear drawing false conclusions because you looked at your data wrong?Įliminate that fear with Excel’s Freeze Panes.
0 kommentar(er)
