More Shift Key Functions

BY STANLEY ZAROWIN

Q. Once when I finished working in Excel and had a bunch of open files, I clicked on the File button to save a file, and lo and behold, saw the menu choice Close All . Wow, what a time-saver! But try as I might, I can’t get the File button to display Close All again. Any ideas?

A. You must have accidentally held down the Shift key when you clicked on File . When you do that, Close changes to Close All (see screenshot below).

Bonus: In Word, when you hold down the Shift key and click on File , Save changes to Save All (see screenshot below).

SPONSORED REPORT

Revenue recognition: A complex effort

Implementing the new standard requires careful judgment. Learn how to make significant accounting judgments and document them and collaborate with peers for consistent application.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

News quiz: Taking an economic snapshot and looking to the future

Recent news included IRS actions that affect individuals and partnerships and a possibly influential move by a Big Four accounting firm.Take this short quiz to see how much you know about the news.