Selecting data in Excel or word pad, shortcuts

  • Thread starter Thread starter Brian in Portland
  • Start date Start date
B

Brian in Portland

Curious if there are any shortcut keys to select a group of data. For
example, I'd like to put the cursor in a spot, hold the shift key and
search for a word and have everything selected between the original
cursor position and the word I search for. This seems pretty basic but
I can't figure it out. I know of the standard shortcuts (control *,
Shift and arrows, shift and page.....) but what about shift and find?

Thanks very much for any help!

P.S. Maybe somebody has a different way to handle this. I'm
downloading data that is bigger than standard excel (maybe 150,000
lines) and don't need all of it - I just some of the summary groups of
items which are scattered throughout the download (SAP). The problem is
the format isn't any good for Access. I have a VBA that reconfigures
after importing to excel. How else can I get rid of unwanted data (I
mean other than using wordpad)

Dave - Can't wait for the book - the help you've given me in the past
has helped tremendously!



***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
I'm not sure how you determine what goes and what stays, but maybe you can use a
helper column and a formula that evaluates to Keep or Delete.

Then filter by that column to show the rows you want to delete. Then select
those rows and delete them. Then remove the filter and delete that helper
column.
 
Back
Top