If you hit a hurdle in Microsoft Excel, press F1 to bring up the Help pane, usually to the right of the window.

When you enter March1, Excel converts it to a date automatically. This is because — in an effort to be helpful — Excel assumes the value is actually the date. You might try pressing Ctrl + Z ...

Now, let’s insert the data validation control. Using the simple demonstration sheet shown in Figure A , click B2. Feel free to use one of your own files if you like or choose another cell.

How to Add and Remove Checkboxes . Excel's Checkbox option is in the Controls group of the Insert tab on the ribbon. By ...

Microsoft Excel 2013 surrounds the active cell with a dark border to help identify the cell you are editing. Pressing the Enter key after editing the cell moves the active cell to the next cell down.

How to insert data. CTRL + K: You can insert a hyperlink. CTRL +, (comma): Inserts the current date. CTRL +: (colon): Inserts the current time. CTRL + ENTER: Used to insert data in all selected cells.

In many versions of Excel, you can use a Microsoft date picker control to create an Excel date drop-down in a cell. Unfortunately, this won't work in 64-bit versions of the popular spreadsheet ...

Press CTRL+C, CTRL+Home, select Paste>Paste Special>Values>OK. Press Escape , CTRL+Home, Right Arrow twice. Hold down Shift , press End , Down Arrow, CTRL+C, Left Arrow, Enter to copy last names.