Excel Trick Tip 1: Change dates like 20050923 to one Excel can “understand”

Suppose you are looking at a worksheet which contains dates which can’t be formatted as “real” dates because of their structure:

Select the date(s), and use Data tab, Text-to-Columns, [Excel2003:Data|Text to Columns]

Which brings up the Text-to-Columns wizard:

Even though the dates are fixed width, in this case you can simply click “Next” twice.

In step 3 of wizard Select Date, YMD:

If you click Finish now, the result will replace the dates. You can select another destination cell:

Here’s the result:

Source


Useful Tips For Excel Keyboard Shortcuts

Useful Tips For Excel Keyboard Shortcuts

1. To format any selected object, press ctrl+1
2. To insert current date, press ctrl+;
3. To insert current time, press ctrl+shift+;
4. To repeat last action, press F4
5. To edit a cell comment, press shift + F2
6. To autosum selected cells, press alt + =
7. To see the suggest drop-down in a cell, press alt + down arrow
8. To enter multiple lines in a cell, press alt+enter
9. To insert a new sheet, press shift + F11
10. To edit active cell, press F2 (places cursor in the end)
11. To hide current row, press ctrl+9
12. To hide current column, press ctrl+0
13. To unhide rows in selected range, press ctrl+shift+9
14. To unhide columns in selected range, press ctrl+shift+0
15. To recalculate formulas, press F9
16. To select data in current region, press ctrl+shift+8
17. To see formulas in the worksheet, press ctrl+shift+` (ctrl+~)
18. While editing formulas to change the reference type from absolute to relative vice versa, press F4
19. To format a number as currency, press ctrl+shift+4 (ctrl+$)
20. To apply outline border around selected cells, press ctrl+shift+7
21. To open the macros dialog box, press alt+F8
22. To copy value from above cell, press ctrl+’
23. To format current cell with comma formats, press ctrl+shift+1
24. To go to the next worksheet, press ctrl+shift+pg down
25. To go to the previous worksheet, press ctrl+shift+pg up


Word for Mac crashes or quits

When you save a Word for Mac document, the application crashes or quits unexpectedly.

Solution

Step 1: Download and install all Office updates

To obtain updates with Office for Mac applications, follow these steps:

Microsoft AutoUpdate for Mac, which comes with Office, can keep your Microsoft software up to date. When AutoUpdate is set to check for updates automatically on a daily, weekly, or monthly basis, there’s no need to search for critical updates and information; AutoUpdate delivers them directly to your computer. To do this:

1. Start any Office for Mac application on your computer.
2. Click Help menu, click Check for Updates .
Continue reading…