Excel

Excel AutoFit Excel Rows and Columns
Excel, MS Office

AutoFit Excel Rows and Columns

Excel rows and columns sometimes needs to be expanded to fit their content. How to AutoFit in Excel? Fortunately Excel allows you to AutoFit Excel rows or Excel columns to its contents readjusting the height or width. In this post I will start with showing how to resize Excel rows and columns. Then I will […]

excel keyboard shortcuts
Excel, MS Office

Microsoft Excel Shortcut Keys

Below are common used Microsoft Excel Shortcut Keys grouped for depending on usage – from Excel Workbook shortcuts to VBA Macro Excel Shortcuts. Use the Table of Contents on the right to navigate. Excel Workbook Shortcuts Shortcuts Description Create a new Workbook Ctrl+N Save the Active Workbook Ctrl+S Save As option for Active Workbook F12 Open […]

VBA Tricks
Excel, MS Office

VBA Tips and Tricks

Instant Print in the Immediate Window Use the “?” preceding a line of code that can evaluate to a value in the VBE Immediate Window. Hit Enter to evalute the code in the next line. See example below: This is a VBA Trick I was not aware for a lot time but saves a lot […]