WebMay 17, 2015 · To check this, press ALT+F11 to bring up the VBA editor and see if there are any modules in your workbook. Also, double click on each worksheet in the editor to see if there is code in any of the worksheets. Any time a macro runs, it clears the Undo/Redo cache. 0 Big Bruiser New Member Joined Dec 15, 2010 Messages 28 Dec 15, 2010 #4 WebFeb 25, 2008 · Have you tried "Unhiding" those columns? Select all cells, (click the square above the 1 for rows and left of the A for columns) Format Columns
"Undo" & "Redo" buttons constantly grayed-out in Excel 2010
WebSep 24, 2024 · 9. Click the Review tab. It's an option in the toolbar at the top of the Excel window. 10. Click Share Workbook. This option is in the "Changes" section of the Review tab. 11. Uncheck the box at the top of the window. This box is next to the "Allow changes by more than one user at the same time" section. WebRemove cell shading. Select the cells that contain a fill color or fill pattern. For more information on selecting cells in a worksheet, see Select cells, ranges, rows, or columns … photo size reduction online
How to Unlock Grayed Out Menus in Excel - Sheetaki
WebFeb 15, 2014 · This one has nothing to do wtih the Trace Dependents or Trace Precedents button, but has to do with undo\redo buttons. When I click on Undo, the Redo button gets active (which is normal), but when I immediately click on Redo, the Redo action doesn't take place. Instead both Undo and Redo buttons grey out. WebDec 14, 2024 · If you have Office 2024 or Microsoft 365, the formula =+K3:K4/K4 will spill to two cells in a column. You can only edit/delete this formula in the top cell. The formula will be grayed out if you select the bottom cell. Sep 01 2024 02:36 AM. Just had this exact problem and came here to find a solution. WebLock or unlock a workbook to make it read-only Note: If your workbook is shared, anyone who has Write privileges can clear the read-only status. For stronger protection, require a … photo size setting online