• Home
  • Knowledge Base
  • Blog
  • Latest comments
  • Tools and resources
    • Password generator
    • What is my IP?
    • Who is – domain name info
    • Screen colour picker
    • How to convert to MP4 and compress videos
    • WCAG Colour Contrast Analyser
  • About

IT Support Guides

  1. Home
  2. Knowledge Base
  3. Excel 2016

Excel 2016 – How to delete empty rows

  • 2

Excel 2013/2016 – How to change CSV delimiter character

    Excel 2016 – How to delete all empty columns

      Excel 2016 – Auto-sum not working until edit formula or save spreadsheet

        Excel 2013/2016 – How to split comma separated values into columns

          Excel 2016 – Formula to calculate age group from age

            Excel 2016 – How to exclude (blank) values from pivot table

              Excel 2016 – What is #DIV/0! error and how to fix it?

                Excel 2016 – How to filter pivot table data

                  How to create named cell references in Excel 2016

                    Latest Articles

                    • How to change decimal precision using Notepad++
                    • Word 2016 – How to change text case
                    • Word 2016 – How to show merge tags
                    • How to change text case using Notepad++
                    • Windows 10 – How to delete “The handle is invalid” folders

                    Recommended

                    Knowledge Base Categories

                    • WordPress
                    • Windows XP Tips
                    • Windows 8
                    • Windows 7
                    • Windows 10
                    • Website Tips
                    • VBS Scripts
                    • Uncategorized
                    • Ubuntu
                    • Technology Tips & Tricks
                    • SQL Server
                    • Server stuff
                    • Server Side Tips
                    • QGIS
                    • Online marketing
                    • Office 2016
                    • Office 2013
                    • Notepad-plus-plus
                    • MySource Matrix
                    • Microsoft Office 2010

                    Tags

                    Adobe Acrobat Adobe Reader CMD ConfigMgr Crystal reports Excel 2013 Excel 2016 Facebook File Explorer Firefox Google Google Chrome Gravity Forms htaccess iPad iPhone iPod jQuery Microsoft Office 2010 Office 2013 Outlook 2010 Outlook 2013 Outlook 2016 PDF PHP phpMyAdmin SCCM Search Silent install SQL SQL Management Studio SQL Server T-SQL TinyMCE TSQL Twitter Ubuntu VLC Media Player Windows 7 Windows 8 Windows 10 Word 2013 Word 2016 WordPress

                    Latest comments

                    • Anthony Gill All I get is "this setting is run by your adminin strator" and no ability to access admin settings. Windows have still not given me a solution.

                      [SOLVED] Windows Defender SmartScreen prevented an unrecognized app error  ·  one week ago

                    • Steven Kayser Hi - I know this is an older post but I'm wondering if this will still be valid today? I am new and not sure where to put this, but this is specific to an image gallery on a single page, not all...

                      WordPress – How to make media library only show current users images ·  one week ago

                    • Rob Still does it.. Annoying AF. Die Chrome

                      Google Chrome – How to stop searching IP addresses when entered in address bar ·  one week ago

                    • Michael Robert Jackson It didn't work with Windows 7, but did point me in the right direction. I used EaseUS Partition Manager (free download and install) and used that to delete all the PS4 partitions and reformat the...

                      How to Format PS4 Hard Drive for PC in Windows 10/8/7 ·  2 weeks ago

                    • it worked thanks!

                      [SOLVED] Lenovo – Built-in webcam camera not working (Windows 10) ·  3 weeks ago

                    Recent Posts

                    • 3 reasons to switch to 1.1.1.1 DNS
                    • 5 ways swim lane workflow diagrams fail
                    • Blocked folder names in Windows 10
                    • How to secure your LastPass account and passwords
                    • Facebook HEARS everything?
                    • About
                    • Donate
                    • Privacy policy
                    • Copyright
                    © Copyright IT Support Guides