Do you want to delete all the hidden rows or columns from your workbook in Microsoft Excel 2016? Here’s how you can do it. How to delete all hidden rows or columns in Microsoft Excel 2016? Open your excel workbook in Microsoft Excel 2016 and then click File –> Info. Sep 15, 2016 Hello All, I am new to the forum. I am running into a problem in excel 2007. When I delete the filtered rows, the hidden rows are getting deleted.
![For For](/uploads/1/2/5/5/125507102/163190773.gif)
Since no one seems to have mentioned a one-key solution here yet (instead of the 2-key 'Fn + Delete' option) I'll suggest the following which is working well for me: 1. Install ' ' This shows up in your menu bar as a square. Click its box, select 'Preferences,' 3. Search for 'backslash delete' (or something appropriate) and check the 'Backslash( ) to Forward Delete (if no other modifiers are pressed)' 4.
Now the assigned key will remove all contents (not formatting) from any selected cells in Excel Benefits:. If you opt to use your backslash key for this purpose, it's situtated perfectly right under the 'delete' key. You can still access a real backslash (' ') by holding down 'Fn' first. You now have a forward delete key for use across ALL your other apps, solving a lot of other problems. Good luck, Garth.
Thanks for the link Skippy I most likely have misconstrued everything on the link you provided, plus the fact that I quickly skimmed most of it on my lunch break. I just tried it on Microsoft Excel using a 'mouse' and it's very easy to point and click separate cells and then proceed to hit the delete key - it works fine - however, I realize now I should've worded it all differently, 'How do you select multiple cells in Excel using just a laptop pad (the little square thing below the space bar - I don't know the right name)?' As we know using a mouse and keyboard we hold down the control key and select the cells with our mouse, but how do we hold down anything with a laptop pad?
I am at work now and cannot go back to try again - but I think I have a good question!!! Or I can just purchase a wireless mouse!!!! Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site.
All postings and use of the content on this site are subject to the.