Quick Excel Tips

Quick Excel tips - making you better at number crunching, data processing, pivot tables, charts and all things Excel and Microsoft Office.

[Quick Excel Tips @blackswantrain]

Mini Toolbar: Don't use the ribbon at the top for formatting. Right-click and use the mini-toolbar instead. #Microsoft #Office365

[Quick Excel Tips @blackswantrain]

Home and End in Word: Jump to the end of the line by pressing the End key. Use Home to jump to the beginning. #Microsoft #Office365

[Quick Excel Tips @blackswantrain]

Alt + Shift + Arrow to Move a Row: Swap a table row or paragraph in #Word or #PowerPoint by pressing Alt+Shift+ an arrow key. The selected row/point will swap places.

[Quick Excel Tips @blackswantrain]

The great thing about being a volunteer for the Federation of Small Businesses is that I can ensure that the needs of SMEs are understood by local authorities and MPs. #ProudToBeFSB

[Quick Excel Tips @blackswantrain]

Shift + Drag to Make a Regular Shape: Drawing a shape in #Microsoft #Office365? Holding down Shift as you drag will make the shape equal on all sides so it's easy to make a perfect square or a circle.

[Quick Excel Tips @blackswantrain]

Ctrl + D to Duplicate: Want a copy of your shape in #PowerPoint? Ctrl+D duplicates the shape, which is a bit quicker that copy and paste.

[Quick Excel Tips @blackswantrain]

Insert Multiple Columns: Want to insert more than one column in Excel? Highlight the number of columns you want. Right-click and choose Insert! Works for rows too, and in #Word & #PowerPoint.

[Quick Excel Tips @blackswantrain]

Ctrl + Enter for Page Break: Type in a Page Break in #Word using Ctrl+Enter. #Microsoft

[Quick Excel Tips @blackswantrain]

Home and End in Excel: Press the Home key to jump to column A. Press End followed by an arrow key to go to the end in the arrow's direction #Excel #Microsoft

[Quick Excel Tips @blackswantrain]

Creating an Appointment from an Email: Drag an email to the Calendar in #Outlook to make an appointment with the email content as the body of the appointment. #Office365

[Quick Excel Tips @blackswantrain]

Change Case: Quickly change make your text upper case by highlighting and press Shift+F3. Keep pressing to cycle between UPPER, lower, Sentence and Title Case. #Microsoft #Word

[Quick Excel Tips @blackswantrain]

Sums in OneNote: If you type a sum in #OneNote it will display the answer like a calculator. Try typing 12*12= followed by a space and 144 will appear. #Microsoft

[Quick Excel Tips @blackswantrain]

Scroll Through Ribbon Tabs Using Mouse Wheel: Try this in Microsoft Office - point at the command ribbon and roll the scroll wheel on your mouse. It scrolls through the tabs! #Word #Excel

[Quick Excel Tips @blackswantrain]

Outlook Favourites: Add folders to your Favorites in Outlook so they are quick to get to by right-clicking them and choose Add to Favorites. #Microsoft

[Quick Excel Tips @blackswantrain]

Special Characters no.5: Get an accented letter in #Word by typing Ctrl+` followed by the letter. EG: è, ò. Start with Ctrl+' to get éóá. Works with capital letters too. Try starting with Ctrl+^ or Ctrl+: for other accents.

[Quick Excel Tips @blackswantrain]

Search Folders: #Outlook's Search Folders list all messages of a type whereever they have been stored. Use to list anything Flagged, Unread or from a person so you can file them in different folders but see them all in one place

[Quick Excel Tips @blackswantrain]

Transpose in Excel: Got column of stuff that you want in a row (or vice versa)? Copy it and then use Paste Special Transpose to paste it the other way #Microsoft #Office365

[Quick Excel Tips @blackswantrain]

Special Characters no.2: Type a copyright symbol © in Word, Excel & PowerPoint by typing (c) followed by a space. #Microsoft #Office365

[Quick Excel Tips @blackswantrain]

Create an Appointment Quickly: Don't waste time clicking New Appointment in #Outlook just highlight the timeslot and type in the subject, press Enter and it's done! Press Enter a second time to open the appt for further edits. #Office365

[Quick Excel Tips @blackswantrain]

Alt+Enter to Make a Line-Break in a Cell: If you want to type separate lines of text in a cell in #Excel type Alt+Enter to put in a line break. For example you can type an address per the image.