Have you been thinking about getting a tablet or a laptop? This affordable Asus machine is both, and you can even use it to run Microsoft Office. Sometimes formatting doesn’t fix the problems within our cells, so we need to edit the data instead. Our how to remove first character in Excel guide will show you an effective way to delete characters from your cells.
Clearing Excel 2013 Cell Formatting
This is especially useful if you receive an Excel file from a client or colleague that has formatting that is preventing you from modifying the document in the way that you need. Erasing cell formatting will allow you to keep the content of the cells (including formulas) while stripping those cells of the unwanted appearance modifications. You can read our article about how to check the format on a cell in Excel if you would like to know what format a cell is currently using. Step 1: Open the spreadsheet in Excel 2013. Step 2: Use your mouse to highlight the cells containing the formatting that you want to remove. Step 3: Click the Home tab at the top of the window. Step 4: Click the Clear button in the Editing section of the ribbon (it’s at the far-right side), then click the Clear Formats option. If you’re looking for an affordable, fast way to print your work documents, then this wireless Brother laser printer is a great choice. Find out how to adjust the print settings in Excel 2013 so that multiple-page Excel files fit to the page more easily. After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites. His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well. Read his full bio here.
You may opt out at any time. Read our Privacy Policy
