Excel Tips
Round Time to the Nearest Quarter Hour »
October 29, 2001
I need to enter a series of time values in military time. Then, I need to total them up and round to the nearest quarter hour.
Make the Header Row Stay Visible as You Scroll Through Data »
October 28, 2001
I have a very long spreadsheet with many columns of numbers. I am looking for a way to make the header row "float" near the top of the data pane while scrolling down for each reference.
Count Text or Numeric Entries with COUNTA instead of COUNT »
October 27, 2001
Is there a function which will count the number of text entries in the column?
Find the Longest Content in Cells »
October 26, 2001
I want to write an formula which calculates the max of length of the column values.
October 25, 2001
I am working on a event code for highlighting the active cell, basically show change the background color of the active cell.
Fill in the Next Empty Row in the Worksheet »
October 24, 2001
I have a worksheet where I input some values. Upon clicking a macro button, I want the values or its calculated results to be appended to a different sheet or file.
Delete a Worksheet in a Macro Without Delete Confirmation »
October 23, 2001
Is there a way in VBA to remove a worksheet which will bypass the "The selected sheets will be permanently deleted. Click OK" prompt?
Add New Months To Excel Chart »
October 23, 2001
A common problem faced by Excel users is they have a chart of time-series data and need to extend the chart with new figures. Editing all of the data series for a number of charts can be time consuming.
Find the Elapsed Time Between Two Time Entries »
October 22, 2001
I need to find the elapsed time between two moments. Each moment has a date and a time. I need to know how much time was elapsed, in minutes or in hours and minutes.