Cannot delete cells in a filtered table
Just started using Excel 2007 and I'm unable to delete individual or groups of cells when I apply a filter. Excel forces me to delete the entire row when all I want is to delete a couple of cells in the row, shift the remain cells left to align the columns
in the report correctly.
While it's easy to work around for a smallish report (cut and paste or drag the cells to align), for larger reports with hundreds of columns this is not viable.
This is really bugging me!
Anwsers to the Problem Cannot delete cells in a filtered table
I hope that I am interpreting your question correctly.
You can achieve the desired result as follows.
1. Select the cell to the right of the one to be deleted.
Hold the both the Ctrl and Shift keys down and press Right arrow.
(Should select ramainder of row unless you have a cell which is blank in which case you may need to press the right arrow more than once to get to the end of the data.)
Right click the mouse over the selected cells and click on Cut.
Right click in the cell to be deleted and then click on Paste.
Added with edit: The above also works if the filtered range is a table.
- Open Internet Explorer.
- Go to "Tools > Internet Options > Advanced Tab".
- Uncheck "Enable third-party browser extensions".
- Click "Apply".
- Reboot your computer.
Recommended Method to Repair the Problem: Cannot delete cells in a filtered table:
How to Fix Cannot delete cells in a filtered table with SmartPCFixer?
1. You can Download Error Fixer here. Install it on your computer. When you open SmartPCFixer, it will perform a scan.
2. After the scan is done, you can see the errors and problems which need to be repaired.
3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in SmartPCFixer. Like dll downloading, junk file cleaning and print spooler error repair.
Related: Best Way to Update & Download Toshiba Satellite A205-S4607 Speech System v.1.00.2520 driver,[Solved] Download Toshiba Satellite C655D-S9511D Face Recognition v.3.1.17 driver,How to Download Toshiba Satellite L655-S5106BN Media Controller Plug-in v.220.127.116.11 driver,Download Toshiba Satellite L845-SP4281RM PC Health Monitor v.18.104.22.168 driver,How Can You Update & Download Toshiba Satellite Pro U500-EZ1321 Web Camera Application v.22.214.171.124 driver,Best Way to Download NVidia GeForce 6100 VGA Driver v.304.51 Certified,How Can You Update & Download NVidia GeForce 9300/nForce 730i VGA Driver v.310.19 Certified,Method to Download NVidia GeForce GT 330M Driver v.340.65,How Can I Update & Download NVidia GeForce GTX 590 Driver v.280.26 WHQL,Method to Download NVidia Tesla C2050 Driver v.319.17,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.126.96.36.19986,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.188.8.131.520,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.184.108.40.2069,Method to Update & Download ASUS K41VD Intel INF Update Driver v.220.127.116.115,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: How to Resolve - Cannot access a SharePoint site collection I created using host header, but others can log into it.?,How Can I Fix - Cannot install update KB951847 error code: 800B0100?,Can't start in Classic MSN, and location is wrong... [Anwsered],Cannot open a URL link from Outlook 2010 email message unless IE 9 is already open. [Anwsered],Solution to Problem: Cannot find command.com,Can't download PP templates automatically to Windows 7 w/IE 8,Can't change drive letter - Vista,Can't change homegroup sharing permission,Can't connect XP shared printer to Win7 except as a local printer.__,Can You Connect the LAN Adapter for Wii On your Windows 7 Laptop?