Thought that I mastered Excel...
Thought that I mastered Excel...
(OP)
My spreadsheets are usually small and easily handled. Copying a cell down a column is quick and easy, just mark the cell, put cursor on lower right corner and drag down. Nothing to it.
But, I now have what I thought impossible in Excel, a sheet with 12 columns and 195729 rows of data. The 'drag corner down the column' method is very awkward. And I cannot find any other way to do it. Surely, there is another way - but how?
Signed
Tired index finger
But, I now have what I thought impossible in Excel, a sheet with 12 columns and 195729 rows of data. The 'drag corner down the column' method is very awkward. And I cannot find any other way to do it. Surely, there is another way - but how?
Signed
Tired index finger
Gunnar Englund
www.gke.org
--------------------------------------
100 % recycled posting: Electrons, ideas, finger-tips have been used over and over again...





RE: Thought that I mastered Excel...
Hold down shift.
end - down (press and release end key, then press down arraow key)
end - right (press and release end key, then press right arrow key)
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Thought that I mastered Excel...
Place cursor in upper left hand corner of the block of data
Hold down shift.
end - down (press and release end key, then press down arraow key)
end - right (press and release end key, then press right arrow key)
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Thought that I mastered Excel...
Ctrl-A
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Thought that I mastered Excel...
RE: Thought that I mastered Excel...
What I usually do is copy down the first column as David said. Then navigate to bottom of the first column (end-down). Then place an X in that bottom row continuing accross as many columns as I think I'll need. Then when I want to copy, I use end-down to get the relevant portion of the column.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Thought that I mastered Excel...
Gunnar Englund
www.gke.org
--------------------------------------
100 % recycled posting: Electrons, ideas, finger-tips have been used over and over again...
RE: Thought that I mastered Excel...
Suppose you want to copy formulas in cells D1:H1 down all way to D195729:H195729.
1. Select range D1:H1 and copy it (ctrl C).
2. Press function key F5 (goto)
3. In reference window type: H195729
4. While pressing Shift key click Ok button. The Range D195729:H195729 will be selected.
5. Press Ctrl-V (or edit/paste) to paste the formulas into selected range.
RE: Thought that I mastered Excel...
So a typical sequence is
ctrl c
ctrl shift down
enter
which copies the first cell in a column all the way down to the end of contiguous data.
Cheers
Greg Locock
New here? Try reading these, they might help FAQ731-376: Eng-Tips.com Forum Policies http://eng-tips.com/market.cfm?
RE: Thought that I mastered Excel...
Put something into the first box in the column that you want to copy all the way down to end of spreadsheet. Double-click lower right corner. Magic!
Thanks.
Gunnar Englund
www.gke.org
--------------------------------------
100 % recycled posting: Electrons, ideas, finger-tips have been used over and over again...
RE: Thought that I mastered Excel...
Hg
Eng-Tips policies: FAQ731-376: Eng-Tips.com Forum Policies
RE: Thought that I mastered Excel...
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Thought that I mastered Excel...
Hg
Eng-Tips policies: FAQ731-376: Eng-Tips.com Forum Policies
RE: Thought that I mastered Excel...
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Thought that I mastered Excel...
-- MechEng2005
RE: Thought that I mastered Excel...
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Thought that I mastered Excel...
I agree there are a lot of things hidden within excel. Who'd of thunk you can double click on the corner of a cell. Or hit "shift" while pressing ok to a dialogue box.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Thought that I mastered Excel...
Thanks!
Hg
Eng-Tips policies: FAQ731-376: Eng-Tips.com Forum Policies
RE: Thought that I mastered Excel...
Home-fill-series... (at the end of the ribbon).
enter columns, and the increment, and 'to' 195729.
Then do the double click thing in the next column on your first cell formula.
PS. did you really need this many rows, or just wanted to enjoy the new real estate in Excel 2007?
RE: Thought that I mastered Excel...
Am doing a test on kWh-meters and have sampled U and I in all three phases, then also recorded the metering pulse. Sampling rate is 3300 Sa/s on each channel and time is 1 minute. I am now letting Excel calculate instantaneous power and accumulated power and compare to the metering pulses.
It seems that the kWh meter does funny things when power is cycled on/off with short intervals during this minute. Can have as much as 15 percent error - too much, most of the customers think.
I was thinking of using Matlab, but decided to test Excel. Really surprised to see that there is room for all these data.
Gunnar Englund
www.gke.org
--------------------------------------
100 % recycled posting: Electrons, ideas, finger-tips have been used over and over again...
RE: Thought that I mastered Excel...
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Thought that I mastered Excel...
RE: Thought that I mastered Excel...
John D
RE: Thought that I mastered Excel...
Gunnar Englund
www.gke.org
--------------------------------------
100 % recycled posting: Electrons, ideas, finger-tips have been used over and over again...
RE: Thought that I mastered Excel...
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Thought that I mastered Excel...
JMW
www.ViscoAnalyser.com
RE: Thought that I mastered Excel...
Hg
Eng-Tips policies: FAQ731-376: Eng-Tips.com Forum Policies
RE: Thought that I mastered Excel...
The procedure is far from obvious, but it's reasonably well described in the help.
h
If that isn't what you meant, please let us know.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Thought that I mastered Excel...
Cheers
Greg Locock
New here? Try reading these, they might help FAQ731-376: Eng-Tips.com Forum Policies http://eng-tips.com/market.cfm?
RE: Thought that I mastered Excel...
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Thought that I mastered Excel...
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Thought that I mastered Excel...
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Thought that I mastered Excel...
Each plot can be "normalized" by dividing by a scale factor (row 29). The scale factor is displayed in the legend. The plot goes from –1 to 1 for all variables
There is also some features built in for easy browsing of a large pile of data... time axis can be changed easily by typing in the green cells "tmin" and "tmax".
http://hom
=====================================
Eng-tips forums: The best place on the web for engineering discussions.