Prefix a cell with an apostrophe (
') to tell excel to treat it as literal text.Disable Auto-Formatting
You can hit the little box between A and 1 to select the entire sheet (or hit ctrl + A) and format it as text.
Disable Auto-Formatting
Frequently Asked Questions
- How to Freeze Columns
- Click on the column you want to freeze.
- Go to
View, clickFreeze Panes. - Select
Up to Column _