Tag: Excel

Remove All Pictures from Spreadsheet

Sometimes you may copy and paste a web page into an Excel spreadsheet, the result may be a spreadsheet peppered with pictures throughout. Too many to individually delete. There is a way to remove all pictures from a spreadsheet by using a macro. Press ALT F8 to get the Macro box. Type in a name and edit it. Copy and…

Read More »

Microsoft Excel – Turn a “1” into “001”

To convert numbers like 1, 10, 100 to 001,010, and 100 within a Microsoft Excel spreadsheet, there are a couople of ways to accomplish this. Format–>Cells, Number tab, Choose Custom and type 000 into the short box at the right. In Excel 2007: From the Home tab, go to Cells, select Format, then Format Cells. Go to the Number tab,…

Read More »