Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to make invisible Columns(A,B,C,......) 1

Status
Not open for further replies.
yummy7

yummy7

Technical User
Jun 2, 2006
195
CA
Hi All,
Is there any way to make invisible/hide A,B,C written in sheet.In the same way Rownames like(1,2,3,.....).I dont want to be visible. Any suggestion is most appreciated.
 
Sort by date Sort by votes
Tools, Options, View tab, uncheck Row & Column Headers

Me transmitte sursum, Caledoni!
 
Upvote 0 Downvote
If your giving this spreadsheet to someone and there is data in cols A,B,C that you just hid that you don't want them to see you should look into Excels protection of worksheets and workbooks. Tools>Protection.

Anyone can simply unhide your columns again by following xlhelp's steps again. This might not be a problem if you don't care about this.

A
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
1K
Andrzejek
Andrzejek
GPnew
  • Locked
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
538
combo
combo
EFFEY
  • Locked
  • Question
I have three columns in excel named 1
Replies
5
Views
218
EFFEY
EFFEY
OCM
  • Locked
  • Question
Compare two columns
Replies
2
Views
1K
OCM
OCM
Metzke
  • Locked
  • Question
How to Transfer Licence to New PC
Replies
11
Views
440
teknance
teknance

Part and Inventory Search

Sponsor

Back
Top