Enlarge Text in Spreadsheet Tabs

BY STANLEY ZAROWIN

Q. My Excel files generally contain a dozen or more worksheets, and each, of course, has its own worksheet tab. The typeface in the tabs is awfully small and I have trouble reading it. Is there a way to make the type larger?

A. Yes, there is. In fact, you can adjust the size, spacing and even the color of many Windows screen features. But first let me tell you how to enlarge the worksheet tabs. Begin by closing Excel if you have it open. The adjustment is done in Windows, not in Excel.

Go to the desktop (the Windows button+D) and place your cursor at any empty location—one without an icon—and right-click. A menu will drop down; select Properties and that will open a new screen. Click on the Appearance tab to call up another screen (see screen shot at right).

Near the bottom of the screen is a box labeled Item: Click on the adjacent arrow until Scroll bar appears. Then move your cursor to the right to the Size: box and increase the number one or two digits. Click on Apply and then OK. Now open Excel and see if the tabs are large enough. If they’re still too small or too big go back and adjust them.

You should understand that you are modifying Windows’ configuration—not just Excel’s, thus any change will affect the scroll bars of other applications, too.

Notice also, if you go back to Item: , that you can adjust many other parts of Windows. I warn you, however, it can become addictive; you can spend hours fiddling with scores of adjustments. But since you do spend hours at the computer, it does make sense to customize it to your liking.

Windows lets you adjust the size of the tabs in an Excel worksheet.

SPONSORED REPORT

Year-end tax planning and what’s new for 2016

Practitioners need to consider several tax planning opportunities to review with their clients before the end of the year. This report offers strategies for individuals and businesses, as well as recent federal tax law changes affecting this year’s tax returns.

QUIZ

News quiz: IRS warning on cyberattacks and a change in pension rules

Once again, the IRS sounds the alarm about a threat from cyberthieves. See how much you know about this and other recent news with this short quiz.

CHECKLIST

Bolster your data defenses

As you weather the dog days of summer, it’s a good time to make sure your cybersecurity structure can stand up to the heat of external and internal threats. Here are six steps to help shore up your systems.