Tips of the Day: Microsoft Excel Short Cut Keys: Alt + H+FF

Microsoft Excel Short Cut Keys: Alt + H+FF


Change Font

Change a font into selected cell.

Tips of the Day: Microsoft Excel Short Cut Keys: Alt + NP

Microsoft Excel Short Cut Keys: Alt + NP

Insert a Picture
Insert pictures from your computer or from other computers that you're connected to.

Tips of the Day: Microsoft Excel Short Cut Keys: Alt + NV

Microsoft Excel Short Cut Keys: Alt + NV

Create a Pivot-table

Tips of the Day: Microsoft Excel Short Cut Keys: Alt + HMC

Microsoft Excel Short Cut Keys: Alt + HMC

Merge & Center Text

Combine and center the contents of the selected cells in a new larger cell.

Create a Dynamic drop down box in Excel 2013

In this tutorial you can make a drop down box connect with another drop down box.

Type your data as show in below figure

Select the Make of Car

 

 

Goto the let top of the sheet you will find the NameBox type the Box in Make and press Enter Key

 

After typing the name box any time you just select the C4 to C6 and you will see the Name Box in Make

Select the D4 to D8 and goto Name Box and type Honda and press Enter Key

 

Tips of the Day: Microsoft Excel Short Cut Key: Using Ctrl + 1

Microsoft Excel Short Cut Key: Using Ctrl + 1

Display the Format Cells dialog box

Tips of the Day: Microsoft Excel Short Cut Key : Using Ctrl + Page Up (key)

Tips of the Day: Microsoft Excel Short Cut Key : Using Ctrl + Page Up (key)

Switches between worksheet tabs, from right-to-left

Tips of the Day: Microsoft Excel Short Cut Keys: Alt + FDA

Microsoft Excel Short Cut Keys: Alt + FDA

Attach a copy of current workbook to default email as a attachment.

Excel Short Cut Keys: Using Alt +AK

Excel Short Cut Keys: Using Alt +AK
Display the Edit link dialog box
in Edit link dialog box you can change, update and open data source and check the status of links and break the link of the current open file.

Excel Short Cut Keys: Using Alt +AK