Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Hiding Columns in Excel 97 or 2000
Name: Rohit Date: November 6, 2000 at 13:03:45 Pacific
Comment:
What is the best way to hide a column which might have formulas and hence need to be a part of the sheet. Before jumping to conclusions try copying your protected sheet and pasting into a new sheet. Now you can unhide the hidden column without a password. Any suggestions. Thanks.
Name: wcr3d Date: November 6, 2000 at 16:47:19 Pacific
Reply:
There is no true way to do this. You can lock the cells but like you say it can be apsted and unlocked. Another is third party software but it is just like Excel and can be gotten around. One last suggestion would be to put it in some obscure place like Row 60000 or column UU. HTH, wcr3d
0
Response Number 2
Name: Bryan Date: November 6, 2000 at 16:57:41 Pacific
Reply:
Password protect the workbook and the copy paste will not reveal the hidden columns.
0
Response Number 3
Name: wcr3d Date: November 6, 2000 at 21:16:44 Pacific
Reply:
No, but it will unlock it. And I think that is the point. wcr3d
Summary: Thanks for the help so far in my problem of trying to convert Quattro Pro files(WB2) to Excel files. Here is the problem again: The place that I work for stopped using Quattro Pro(spreadsheet program)...
Summary: Anyone know of a good online tutorial on how to do an amortization table/schedule in Excel 97? I know 2002 and possibly 2000 have built-in amort tools. Any help is appreciated. ...
0 
