Skip to content
Sebastian.Expert
  • Home
  • Search
  • Office
    • Excel
    • Word
    • Outlook
  • Tips
    • WordPress
    • Programs
    • Web
  • Android
  • Programming
    • Visual Studio
    • SQL Management Studio
    • SharePoint
    • .NET
  • 3D Printing
  • Arduino
  • Windows
    • Windows Server
    • Windows 10
  • Contact Me – Ask me a question!

Excel 2016

Print Areas in Excel – All You Need to Know

April 13, 2019November 27, 2018 by Sebastian Expert
Excel Logo Print Area

Table of Contents Create one or more print areas View a print area Add cells to an existing print area … Read more

Categories Excel Tags Excel 2013, Excel 2016, Excel 2019, Excel 365, Office 365

Changing Default Save File Format in Word, Excel, PowerPoint 2016

June 26, 2018May 1, 2018 by Sebastian Expert
default save file format word excel powerpoint

In Office 2007, Microsoft introduced new extensions: xlsx, docx, ppts etc. which are no longer binaries but based on Office … Read more

Categories Excel Tags Excel 2016, PowerPoint 2016, Word 2016

How to Create Drop Down List in Excel – Step By Step Guide

July 13, 2018April 3, 2018 by Sebastian Expert
Excel - DropDown

This article will show you how to add/create a dropdown list control in Excel so that the user can select … Read more

Categories Excel Tags Excel 2013, Excel 2016

How to Get Unique/Distinct Values From a Column in Excel

April 19, 2018March 20, 2018 by Sebastian Expert
Getting unique/distinct values from a column in Excel

Lets say that you have a column with values, and you need to find out what distinct/unique values are in … Read more

Categories Excel, Office Tags Excel 2013, Excel 2016

Excel – Change Units of Measurement to Inches, Centimeters or Milimeters

May 7, 2018January 21, 2018 by Sebastian Expert
change-units-excel-advanced-options

By default, Excel takes units of measurement from the system settings. Sometimes, however, these settings are not the ones we … Read more

Categories Office Tags Excel 2013, Excel 2016

Restore missing formula bar in Excel 2013/2016

January 21, 2018January 20, 2018 by Sebastian Expert
show-formula-bar-excel-options

There is nothing worse than those the little annoying problems that pop up just when we have an important job … Read more

Categories Excel, Office Tags Excel 2013, Excel 2016, formula bar, tip
Post navigation
Older posts
Page1 Page2 Page3 Next →

Do you like what you read? Don't miss updates!

Once a week you will receive summary of new articles on my site.
You can unsubscribe in one click and I will never share your email address.

Recent Comments

  • din on Fix for “This could be due to CredSSP encryption oracle remediation”, Tuesday, 8 March 2022
  • Anonymous on Could not find USBtiny device (0x2341/0x49), Thursday, 25 November 2021
  • Asim Khan on Fix WordPress – An error occurred in the upload. Please try again later, Tuesday, 21 September 2021
  • Anonymous on Could not find USBtiny device (0x2341/0x49), Saturday, 10 July 2021
  • nadia on Fix WordPress – An error occurred in the upload. Please try again later, Wednesday, 18 November 2020
DMCA.com Protection Status
Copyright 2019
Privacy Policy
© 2023 Sebastian.Expert