![]() Sometimes I'll have three or more workbooks open that I want to quickly flip through. If you have a bunch of files open and want to close them all at once so you can get out of the office quicker, then check out my post on 3 Tips to Save & Close All Excel Files. ![]() You can also paste in folder paths to the address bar for quick navigation to a different folder. However, I tend to prefer the Save As window because you can rename and change locations in one place. ![]() You can set this view to open when pressing F12 by going to Excel Options > Save and uncheck “Don't show Backstage when opening or saving files with keyboard shortcuts.” The latest versions of Excel also make file renaming easy on the File > Save As Backstage view. The shorcut for the Save As window on the Mac version is: Cmd+ Shift+ S Checkout my article on the best keyboards for Excel for more info on that. If you are using a laptop or keyboard with multi-purpose function keys you might need to press Fn+F12. The keyboard shortcut to open the Save As window is: F12 If you want to save the file you are currently working on with a different name or in a different folder, then you need to open the Save As window. In this post, I'm going to share the three that I probably use the most to save time with these common tasks. There are a ton of shortcuts for navigating and interacting with Excel workbooks. Bottom line: Learn 3 quick shortcuts to save, close, and navigate Excel workbooks.
0 Comments
Leave a Reply. |