• 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

            How to create named cell references in Excel 2016

              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

                    Latest Articles

                    • Google Chrome – How to enable extensions in incognito
                    • How to bulk remove twitter likes
                    • How to bulk remove Twitter tweets and retweets
                    • How to bulk remove Twitter users you are following
                    • How to bulk unfollow Twitter followers

                    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
                    • Online marketing
                    • Office 2016
                    • Office 2013
                    • MySource Matrix
                    • Microsoft Office 2010
                    • Microsoft Office 2007
                    • Joomla Tips

                    Tags

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

                    Latest comments

                    • Tayfun Ilme Not work. last page Short time i cant change , because no option for change or cant write words.

                      Windows 10 – How to change clock to 12 hour – show AM/PM ·  3 days ago

                    • Pablo Aguirre I'm afraid you're mistakenly changing the name of the "group policy editor" (gpedit) to "registry editor" (regedit) which home editions do have.

                      Windows 10 – How to disable Recent Items and Frequent Folders history ·  one week ago

                    • Mr.Blix You should state that this only works on the drive where your OS is installed. For me its installed on a ssd. this doesn't do anything because its a ssd. my hdd is my secondary drive and thats where...

                      Windows 10 – How to control hard drive power down ·  one week ago

                    • gjm Great article, thank you very much for this.

                      IrfanView – Thumbnails not displaying in Windows Explorer ·  2 weeks ago

                    • michbeck0711 perfect, i searched for this.But will this automatically work for all the forms i already made? I am asking since i have several dozens on my site and i don't want to have to setup each one of...

                      Gravity Forms – How to require all checkboxes ticked ·  3 weeks ago

                    Recent Posts

                    • Why UX is more important than SEO
                    • Annoying web trends that need to stop
                    • Free stock images for your web design projects
                    • Firefox fights Google Chrome with speed and resources
                    • WordPress 4.9 is out! And it’s awesome!
                    • About
                    • Donate
                    • Privacy policy
                    • Copyright
                    © Copyright IT Support Guides