Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a large table of data (not created by me) with more than 1500 rows. The first column of which is a list of dates, monthly, starting from 1870. Some of the columns contain data for the full rage of dates while in others data is available only in more recent times. I want to experiment plotting all sorts of combinations of columns and date ranges. I have two issues hampering me.

  1. Getting the dates to show properly on the graph. If I select entire columns, then I neatly get the dates showing along the X axis. But if I select just a small date range then the graph seems not to realise that the date column is in fact dates, instead the dates get treated as ordinary numbers. The date format is perhaps ambiguous because they are written like "1883.2" meaning February 1883. Is there some way I can ensure that excel knows that the dates are dates and not numbers?

  2. To select slices of data I am clicking on the top cell and then dragging the mouse to the bottom of the screen and then waiting ages till the end data is reached. There must be a quicker way!

EDIT: After some more research I have a solution to 2. I select "window" then "split". I can now see the start and end points of my date range on the screen at the same time...

share|improve this question

2 Answers 2

To solve number 2 (Selecting all the data in the column):

Select the first cell you want and then use the keyboard shortcut Ctrl + Shift + Down Arrow

It will stop at the next blank cell, so if you have blanks in the middle just keep using the shortcut.

share|improve this answer

You should be able to format the axis so that the values are displayed as dates, after you've created the graph. Right-click on the axis and go from there.

And there is a keyboard shortcut for selecting an entire column, but I can't remember what it is. Don't quote me, but I think it might have been Home Home Pgdn.

There ought to be a website somewhere with Excel keyboard shortcuts.

Dragging all the way down the worksheet sounds familiar, I've done it many times, and with a lot more than 1500 rows.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.