This blog post is about 4 different methods to Display Formulas in Excel. Following is the screenshot of the data used to explain the different ways for displaying formulas. Show Formulas button To display all those formulas used in a worksheet, go to the Formulas tab in the Excel ribbon and click on Show Formulas … Read more
Changing the Column Width or Row Height automatically to fit the contents is called AutoFit in Excel. 4 different methods to AutoFit Rows and Columns in Excel are explained in this blog post and the following is the data used for explaining these methods. AutoFit Rows and Columns manually Select the entire Worksheet by clicking … Read more
A few lesser-known, but pretty useful Keyboard Shortcuts in Excel are explained in this post. 1. Legacy shortcut for Creating Table Ctrl + T is a very popular Excel shortcut that is used to create Tables. But there is one more shortcut for creating a Table in Excel and that is Ctrl + L. Select … Read more