Thanks! Even old time Excel users like myself miss some of the very useful shortcuts, especially if you never needed them before! 👍
@excelisfun
6 жыл бұрын
Love the Sort to Delete : )
@alirezamogharabi8733
6 жыл бұрын
Thanks a lot Bill, please make a video about custom table formatting or modifying existing formats. thanks.
@scottwilkerson1208
Жыл бұрын
I've got about thousand columns to the right of my data. Anyway to get rid of those? Your methods above do not work.
@kiranraika4540
6 ай бұрын
You talk a lot and but your work is excellent It would be very nice if you finished your video in 1min instead of 5min ❤ see from the audience perspective as well
@lynnmichalski2729
3 жыл бұрын
Saved me so much time!
@anoopvasudevan509
4 жыл бұрын
Wonderful, thank you.
@DougHExcel
6 жыл бұрын
Thanks for the sorting tips!
@ismailismaili0071
6 жыл бұрын
It's just OMG thank u Mr. Bill love u
@Videokeys
Жыл бұрын
how to delete blank columns if its in table format? this only applies if the cells aren't formatted table; please help, thanks in advance!
@MrXL
Жыл бұрын
Thanks for posting this comment. Before this comment, I hated Tables almost as much as I hate merged cells. I never realized that "Format as Table" turns off Left to Right sorting (from 2:13) in the video and also turns off Delete Columns. In the lead-up to Office 2007, the Excel team realized that Tables could not be finished in time and wanted to rip them out of the product. But it was too late, there wasn't time to remove all the code. Office 2007 shipped with Tables in their broken state. Then a reorganization sent the Tables team to other departments and now, 16 years later, we are still left with this travesty of a feature. My only advice is to select a cell in the Table. Go to Table Design tab in the Ribbon. The 3rd command in the second column of icons is "Convert to Range". Use this to convert to a regular range. Use one of the two methods in this video. Then, if you need to, make this into a table again.
@palakodetibangarurayudu9686
6 жыл бұрын
Thank you
@semperdiscendum7439
6 жыл бұрын
Awesome! Thank you! 👍👍
@krn14242
6 жыл бұрын
WOW... Can't even call that a data set. Mike Girvin is cringing I'm sure. Great trick to delete all columns though.
@vfran838
4 жыл бұрын
This is great but goes too fast.
@MrsDotWhit
2 жыл бұрын
Way too fast. Sorry
@ashaydwivedi420
6 жыл бұрын
Omg 8th view 1st comment 1st like
@solutionsaec9129
3 жыл бұрын
Your speaking too fast for a real novice to follow
Пікірлер: 20