Header Banner
wonderhowto.mark.png
Gadget Hacks Next Reality Food Hacks Null Byte The Secret Yumiverse Invisiverse Macgyverisms Mind Hacks Mad Science Lock Picking Driverless

How to Hide scroll bars, sheet tabs & charts in Excel

Apr 20, 2010 05:45 AM

This video is a tutorial on how to remove scroll bars, sheet tabs and objects in Excel. To remove scroll bars and sheet tabs, go to the Office button, then Excel Options. On the screen that comes up go to the Advanced tab and scroll down to "Display options for this workbook", where you will see some check boxes. Uncheck the boxes for horizontal scroll bar, vertical scroll bar and sheet tabs. This will remove them from the current workbook. This feature only works with the current workbook. To hide objects in the workbook go to the Office button, Excel Options, the Advanced tab, and down to "Display options for this workbook". Where it says "For objects, show" click "Nothing (hide objects)". Now you will not be able to see the objects that were in the workbook unless you go back and recheck the box. To hide objects individually, select the object, go up to the Format tab and click Selection Pane. A menu will pop up showing all the objects in the worksheet. Simply click the box for the one you want to hide.

You already know how to use your phone. With Gadget Hacks' newsletter, we'll show you how to master it. Each week, we explore features, hidden tools, and advanced settings that give you more control over iOS and Android than most users even know exists.

Sign up for Gadget Hacks Weekly and start unlocking your phone's full potential.

Related Articles

Comments

No Comments Exist

Be the first, drop a comment!