Set Default to Copy and Paste Visible Cells Only
Hello, Does anyone know if we can set the Copy and Paste Function to default into copying and pasting only the visible cells? I'm using Excel 2016 in Windows 10. I've been doing the Alt + ; and then copying it way but when copying, I never want the hidden cells anyway. So I'm wondering if this could be set as default to avoid the extra step. Thanks!
Seeing and advancing through all tabs -- arrows in bottom left corner not working
I created a workbook in Excel on a Mac with 15 tabs, meaning that not all tabs are visible at the bottom of the screen. I can use the arrows in the bottom left corner of the window to advance through the tabs and change the series of tabs visible at the bottom on a Mac. However, on a PC, the arrows at the bottom do not change which tabs are visible and do not allow me to advance through the tabs. This is specific to this workbook on a PC; other workbooks on the PC do allow me to use the arrows in the bottom left to see and move through tabs. I know there are workarounds like right-clicking and seeing a menu of all tabs and keystrokes to advance through all tabs. But I am wanting to know the cause and solution of the bottom left arrows not working.
