Hiding Values in Excel 2013 Cells, Some abstracts is all-important for functions and tools, but is confusing on an contrarily apple-pie worksheet. To accumulate your area neat, adumbrate the abstracts application the Format Beef feature. While they won’t arise in the cells, you can still verify the ethics by selecting the beef and searching in the Blueprint Bar.
1. Baddest the beef that accommodate the abstracts you wish to hide.
2. Right-click anywhere in the called ambit and bang Format Beef from the pop-up menu.
3. Bang the Number tab and baddest Custom from the Category list.
4. Access ;;; (that’s three semicolons) in the Type acreage and bang OK.
5. Appearance the aboriginal abstracts to see that it’s hidden on the sheet.
This adjustment not alone hides the abstracts on the sheet, but aswell on printouts, so you’re ensured a apple-pie output.
Note that you can still appearance the ethics in called beef by searching in the Blueprint Bar. To aswell adumbrate the blueprint in the Blueprint Bar, analysis Hidden in the Format Cells’ Aegis tab and bang Assure Area in the capital Review tab’s Changes group.
Leave the defaults as they are, but you can optionally access a countersign to anticipate others from disabling protection. Bang OK to assure the spreadsheet.
1. Baddest the beef that accommodate the abstracts you wish to hide.
2. Right-click anywhere in the called ambit and bang Format Beef from the pop-up menu.
3. Bang the Number tab and baddest Custom from the Category list.
4. Access ;;; (that’s three semicolons) in the Type acreage and bang OK.
This adjustment not alone hides the abstracts on the sheet, but aswell on printouts, so you’re ensured a apple-pie output.
Note that you can still appearance the ethics in called beef by searching in the Blueprint Bar. To aswell adumbrate the blueprint in the Blueprint Bar, analysis Hidden in the Format Cells’ Aegis tab and bang Assure Area in the capital Review tab’s Changes group.
Leave the defaults as they are, but you can optionally access a countersign to anticipate others from disabling protection. Bang OK to assure the spreadsheet.
Blogger Comment
Facebook Comment