All articles with 'settings' Tag

Automatically insert timestamps in excel sheet using formulas

Published on Jan 8, 2009 in Learn Excel
Automatically insert timestamps in excel sheet using formulas

Often when you use excel to track a particular item (like expenses, exercise schedules, investments) you usually enter the current date (and time). This is nothing but timestamping. Once the item is time stamped, it is much more easier to analyze it. Here is an excel formula trick to generate timestamps.

Continue »

Custom Views in Excel – Save filter and header settings for quick reference

Published on Dec 17, 2008 in Learn Excel
Custom Views in Excel – Save filter and header settings for quick reference

PHD reader and commenter Vishy contributed this post through e-mail. Thank you so much Vishy for this very useful tip. The Problem: You have created a specific view of your data in Excel (say by filtering, zooming out, changing column width, hiding specific rows, customizing window settings, print settings etc.). This is your reference point […]

Continue »