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 »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 »There is a spreadsheet with data that needed to be reorganized from columns to rows so that it would be easier to read. There must be a method native to Microsoft Excel 2003 that would allow for this seemingly simple request. The goal is to perform this task with only a few key strokes and mouse clicks without having to…
Read More »