Replace The Missing Close Icon in Excel

BY STANLEY ZAROWIN

Q. My version of Word contains a Close icon (for closing an open file). But in Excel, there’s just the word Close —no icon. What’s up? Do I have an economy version of Excel—one with limited icons?

A. No, all copies of Excel are that way. It must be an oversight by Microsoft. However, it’s easy enough to correct just by copying a Close icon from another application and pasting it into Excel. Icon copying is possible between all Microsoft applications.

In fact, as I was thinking about your question, it occurred to me that the solution opens some interesting possibilities for a handy and easy way to customize icon displays in any application.

Here’s how to add the icon in Excel, recognizing that this method can be adapted to other applications, too. First open Excel and click on Tools, Customize , and when the dialog box opens, click on the Commands tab and then on File . Scroll down to the word Close (notice there is no icon) and, using your mouse, drag the word to your toolbar.

Now open Word, and again click on Tools, Customize , and when the dialog box opens, click on the Commands tab and then on File. Scroll down to the Close icon and drag it to the toolbar.

Once it’s in the toolbar, right click on the icon, and in the screen that appears choose Copy Button Image.

Then switch back to Excel, put your cursor over the word Close and right click, again evoking the above screen. This time select Paste Button Image while your cursor hovers over the word Close and—presto!—the icon appears. Finally, click on Modify Selection, choose Default Style and click on Close to quit the dialog box.

This technique can be adapted if you want to customize other functions with an icon of your choice.

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.