Monthly Archives: November 1997

Changing columns to rows, and vice versa

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

Posted in Spreadsheets | Comments Off on Changing columns to rows, and vice versa

Scrolling along

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

Posted in Spreadsheets | Comments Off on Scrolling along

AutoSave

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

Posted in Spreadsheets | Comments Off on AutoSave

Quick navigation through worksheets

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

Posted in Spreadsheets | Comments Off on Quick navigation through worksheets

Entering a date into a number-formatted cell

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

Posted in Spreadsheets | Comments Off on Entering a date into a number-formatted cell