erasing the column (A.B.C.D.) row(1,2,3,4...) Labels

OWAIZ

Board Regular
Joined
Jun 20, 2002
Messages
89
Hi champs,

a small query.. i have an excel sheet wherein i dont want the column labels a,b,c, d,e, & row label 1,2,3,4,5,....

i just want my sheet to look like a plain page without any 1)rulers, 2)button, 3)toolbar, no bar, when we open this file, it should be 1 screen without anything on it..

possible?

pls help if u know the way

thanks & regards
owaiz
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

bolo

Active Member
Joined
Mar 23, 2002
Messages
423
go to tools, options and remove tick from row and column headers. HTH
 

OWAIZ

Board Regular
Joined
Jun 20, 2002
Messages
89
Thanks buddy, for such a quick and helpful reply, can u pls guide me a way to remove all the button and toolbar. and let my only this particular sheet look like 1 screen only

thanks & regards
Avesh
 

bolo

Active Member
Joined
Mar 23, 2002
Messages
423
you could right click on the bar on the top and unclick all the ticks. This removes all the buttons.

regards
 

bolo

Active Member
Joined
Mar 23, 2002
Messages
423
you could right click on the bar on the top and unclick all the ticks. This removes all the buttons.

regards
 

Forum statistics

Threads
1,144,056
Messages
5,722,256
Members
422,419
Latest member
Havok390

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top