Your work is clear

BY J. CARLTON COLLINS, CPA

Q: Our satellite offices provide temporary office space to visiting staff, and each office is equipped with a shared computer. I frequently use these office computers, but after I’m done I am not comfortable that Word and Excel display the names of the most recently opened files, because this allows other users to tell what I am working on. Is there a way to reset or clear the recently opened files list?

A: You can reset the recent files lists in the 2013, 2010, and 2007 editions of Excel or Word by selecting File, Options, and from the Advanced menu, under Display, setting the spinner box labeled Show this number of Recent Workbooks (or Documents) to 0, and then clicking OK. Then repeat this step to set the spinner back to its original setting. Afterward, the list of Recent Workbooks (or Documents) displays as empty, but will continue to collect and display recently opened file names for subsequent users.

RESOURCES

Keeping you informed and prepared amid the coronavirus outbreak

We’re gathering the latest news stories along with relevant columns, tips, podcasts, and videos on this page, along with curated items from our archives to help with uncertainty and disruption.

VIDEO

Excel walk-through: Sparklines

Want to liven up your spreadsheets with some color and graphical elements? Kelly L. Williams, CPA, Ph.D., shows how to use Excel sparklines, which illustrate data trends and patterns via small charts that fit in a single Excel cell.