Excel Worksheet Tips: Keyboard Shortcuts

Excel Worksheet Tips: Keyboard Shortcuts I was searching for a particular shortcut but unfortunately I was unable to find the one I was looking for; however I have found many more. Check out all these useful shortcuts here. Come check out the directory for the rest of my excel tips! Submeg IT

Read More

Excel VBA Tips: Closing All Non-Active Workbooks

Excel VBA Tips: Closing All Non-Active Workbooks If you ever need to close off all the workbooks you have open in the background but don’t want to have to navigate to each one, this code is extremely useful. Public Sub CloseAllInactive() Dim Wb As Workbook Dim AWb As String AWb = ActiveWorkbook.Name ‘Your code here,…

Read More

Excel VBA Tips: Remove Password from Worksheet

Excel VBA Tips: Remove Password from Worksheet There have been many times when I’ve password protected an excel worksheet or workbook and then forgotten what it was. Wanting to modify the sheet later, I then realise I can’t, as I don’t remember what the password is! However, there is a way around this! Remove worksheet…

Read More

Excel Worksheet Tips: Average Without Zeros

Excel Worksheet Tips: Average Without Zeros Have you got a collection of data that you wish to take the average of, but do not want to include zeros? By including them, it will alter the average you are looking for. Excel 2003 =SUM(A1:A10)/COUNTIF(A1:A10,”<>0″) Excel 2007 & 2010 =AVERAGEIF(A1:A10,”<>0″,A1:A10) This is the quick way to use…

Read More

Excel Worksheet Tips: Hiding Buttons When Printing

Excel Worksheet Tips: Hiding Buttons When Printing You may have a sheet that contains buttons, which when pressed, perform an action. When printing an active sheet, these buttons will be displayed on the printout. This may not be desired, as it doesn’t look professional. To remove these from printing: 1. Ensure you are in design…

Read More