How to Show / Add Developer tab in Excel 2013

The Developer tab is not displayed by default, but you can add it to the ribbon

Tips of the Day: Microsoft Excel 2013 Short Cut Keys: Alt + WVG (Show or Hide Gridlines)

Show or Hide Gridlines

Microsoft Excel 2013 Short Cut Keys: Alt + W+V+G 
Hit the Alt key. Then type WVG (one key at a time).


Show or Hide Gridlines
Show the lines between rows and columns in the sheet to make the sheet easier to read.
Hide the lines for view sheet as same as print view.

raj-excel.blogspot.com Show or Hide Gridlines (Alt + WVG)

Tips of the Day: Microsoft Excel 2013 Short Cut Keys: Alt + NH (Add a Header & Footer)

Add Header & Footer

Microsoft Excel 2013 Short Cut Keys: Alt + NH
Hit the Alt key. Then type NH (one key at a time).

Add Header & Footer
the content of the header and footer repeats at the top and bottom of each printed page.
This is useful for showcasing info, such file name, date and time.

Tips of the Day: Microsoft Excel 2013 Short Cut Keys: Alt + PG (Background Picture)

Insert Background Picture

Microsoft Excel 2013 Short Cut Keys: Alt + P+G 
Hit the Alt key. Then type PG (one key at a time).

Insert Background Picture

Choose a picture for your background and add some personality to your worksheet.

raj-excel.blogspot.com (Insert Background Picture - Alt PG)

Tips of the Day: Microsoft Excel 2013 Short Cut Keys: Alt + NI or Ctrl+K (Add a Hyperlink)

Add a Hyperlink

Microsoft Excel 2013 Short Cut Keys: Alt + NI
Hit the Alt key. Then type NI (one key at a time).

or Ctrl+K

Add a Hyperlink
Create a link in your document for quick access to webpages and files.
Hyperlinks can also take you to places in your documents

raj-excel.blogspot.com (Add Hyperlink - Ctrl+K)

How to link update automatically in Excel 2013 without any notification when file open

Often when we link one workbook with another workbook and when we close and re-open the linked workbook a message appear on screen (see below snapshot)

Excel 2013 Short Cut Keys: Shift+F11 (Insert Worksheet)

Microsoft Excel 2013  / 2016 Short Cut Keys: Alt + H+I+S or Shift+F11 (function key)
Hit the Alt key. Then type HIS (one key at a time).


Insert the new sheet.

Update for the Master Data Services (MDS) Excel add-in

The MDS team is proud to announce an update to the Master Data Services Excel add-in. This version includes a number of performance improvements - most users will see an improvement of up to 4x to load data from an MDS server, without any additional server or environment changes. For additional performance increase (2-4x), you can enable dynamic content compression in IIS.