Category Archives: Spreadsheets

During worksheet development, you might find that you wish you had put your data in rows rather than columns, or columns rather than rows. The problem with this scenario is that you don’t want to make all these changes by … Continue reading →

There are two ways to scroll through an Excel worksheet without changing the cell selection. One way is to use the scroll bars. You can scroll anywhere you want by clicking on the vertical or horizontal scroll buttons. It doesn’t … Continue reading →

By default, when you use Excel’s Add-in AutoSave, the program will prompt you when it’s time to save the document. If Excel is minimized when the time for a save comes, its taskbar icon will blink. So, if you see … Continue reading →

Version 95, 4.x – If you want to move to a new sheet in Excel, press Ctrl-Page Down. To move to a previous sheet, Lifestyle tips, delicious diabetic prescription viagra prices recipes, answers for your queries, we deliver them right … Continue reading →

Version 4.x, 95 – If someone inadvertently types a date into a cell formatted for numbers, there’s no error generated–you just get some incorrect numbers. Actually, you get the number that represents the date, but not in date format. Excel’s … Continue reading →

Version 4.x, 95 – If you want to set the format of a cell or group of cells, all you have to do is select the cells, choose Format|Cells, and then select your format from the dialog box. However, you … Continue reading →

Progress marches on. In Excel 97 Viewer, you cannot edit any Automation objects in an open Excel 97 workbook. You have to edit from Excel itself. This, however, should not online viagra sales be misconstrued to mean that Kenpo Karate … Continue reading →

Version 4.x, 95 – You probably know that drag-and-drop action applies in Excel as well as in Word. But if you’ve tried it in Excel, you may have given up! The problem is, while drag and drop works in Excel, … Continue reading →

Version 4.x, 95 – Having your toolbars at the top of the window is usually OK. But there are times, especially in Excel or PowerPoint, when you’d like to have a toolbar in a different location to make it easier … Continue reading →

Version 4.x, 95 – If you want, you can expand a small worksheet’s printout to make it more legible, or just more impressive. Choose File|Page Setup and click on the Page tab. Use the Adjust To spin box to set … Continue reading →