Комментарии:
I love you.. you have given me so much belief in my excel skills that I always believe in myself no matter what my psycho boss says 😂
ОтветитьClick the column header, this selects the whole column, then Control-Shift-Up arrow. Done
Ответитьyou can improve this further by selecting the whole row. insteat of selelcting b1:b10000 you use b:b. This has the advantage to be shorter and you don't have to think which low end cell you have to select to get last number.
ОтветитьCtrl space then ctrl shift up
Ответитьhope less
ОтветитьThank you Leila!!!
ОтветитьGr8
Ответитьvery useful indeed!! thanks so much
ОтветитьI used to convert it to table (ctrl + T), and use the down arrow near column header to select the specific column range
Ответитьyour explanation beautiful and you are beautiful also
ОтветитьI love the wealth of knowledge you share with us Leila, even with little things like this. But, I also love how many of your followers share other tips and trips and @Gautam K Banik's way of select the items in a column with blanks was a fantastic contribution.
ОтветитьYou can also use ctrl + spacebar
ОтветитьThank you Very Much Madam You solved My problem. I Prayed for you. God Bless You.
Ответить@Leila, for selection of entire column. (Ctrl + spacebar) is also a shortcut key for selecting an entire range of column including blank cell as well.
ОтветитьHi Leila, I am really impressed with your method of explanation. It's just WoW.
Can you please come up with video on how to automate process of copying Image to OneNote, Apply Copy Text from picture function of OneNote, and paste it in Excel.
Thanks!!
We Have no Skill So no Share
ОтветитьAddendum - Extra Method #3, please review the steps. I do not get the result the way you get it on video or your detailed article. Certainly steps to be revised on Office 365.
Ответитьthanks
ОтветитьRarely am I worries about 1-x, I’d rather grab the whole column with CTRL+Space Bar
ОтветитьPart 2 is must if u are not satisfied here
ОтветитьGreat tips. Thanks a ton. Are there any disadvantages to using ctrl + Spacebar in this situation ?
ОтветитьWhat is the shortcut for selecting a single column while some cells are merged?
ОтветитьLeila, don't you have any video on how to copy and paste only visible cells on Office 365. Sometimes it works and sometimes it does and I also need to know let us say I have 10,000 records and after a few filters, there are around 300 values which I have to delete one by one. It takes a lot of time when I delete them individually as I don't want to mess up my such a big file of 10,000 records. I don't want that it deletes some values which should not be deleted. Thanks
ОтветитьTONS of Thanks!! that's really helpful...
ОтветитьGood effort, keep on, learning too much from your videos.
ОтветитьHi, I have found that if the data is in the form of a table, that simple Ctrl-Shift works.
ОтветитьPress Ctrl+ space and than up arrow will also work
ОтветитьI accomplish this daily by simply pressing and holding Ctrl+shift+down until it hits the final row. Then I move my finger from down to up. Mission accomplished!
ОтветитьCrtl+Space then Ctrl+Shift+Up works for me.😃
ОтветитьGreat thanks
ОтветитьAll taking about (ctrl+space than ctrl+shift+up) but you gonna do when your data start with row 2 or 3..?? Good job Leila thanks
ОтветитьHi,
Before naming the range, select data with blanks using below shortcut:
CTRL + Space bar to select the column and then
CTRL + Shift + Up arrow key
Ctrl+space ===then==>> Ctrl+shift+up
ОтветитьI don't get why you wouldn't just use Ctrl+Space Bar. If you're highlighting beyond your data set, then why not just do the whole column?
ОтветитьHello Mam... I use Ctrl+Shift+end and use arrow keys as required....
ОтветитьJust 1 shortcut key which i used ctrl+shift+end
ОтветитьThanks for this. I really enjoy learning Excel from your channel. Specially Xlookup. Thank you so much 👍
ОтветитьThanks a lot for this wonderful gift. Its very good.
Ответитьjust select the column and ctr+shift+up
Ответитьu have too focoos guys
ОтветитьDear All, can anyone tell me how can I lock CONDITIONAL FORMATTING formulas of my EXCEL so that any COPY/PASTE operation on my sheet is NOT SCREWING my CF Formulas?
Ответитьfrom the first cell in the column use ctrl+shift+end which selects the entire data set then release the ctrl key and use the right/left arrows to select the column desired independent of spaces
ОтветитьHello M’am - The shortcut followed by me is
Step 1: CTRL+END then HOME: cursor moves to the last row of the first column (A),
Step 2: Navigate to target column (mouse or arrow keys)
(say col D or S)
Step 3: In cell address type "col&1" (say D1 or S1),
Step 4: then SHIFT+ENTER
Just click CTRL+SPACE and then CTRL+SHIFT+UP
ОтветитьThanks for introducing the Skillshare. Huraaa I won a 2-month coupon. Thanks for that too. I am looking for a shortcut, which I used to use long time ago. I have forgotten it and I am not sure if it exists in new versions. Here it is: . I have split my sheet into 4 parts. Let say my cursor is in part one. I know f6 will cycle through the four parts and menu bar. But what if I am in middle of part one and I want to move to top of that part. I think there was a shortcut for it.
ОтветитьOne more simple way, which I'm using is ctrl+space bar, then shift+ctrl+up arrow key - done
ОтветитьHi Leila I need to design a supplier database, can you please assist me a best solution.
ОтветитьHey, thanks a lot for this short one, but really useful. Make tasks less annoying.
ОтветитьExcellent
Ответить