However, when working with a cell containing multiple lines of text, it can be frustrating to create a new line.

Below are the keyboard shortcut keys to make this task easy.

When ready for a new line, press and hold down the Alt key, then press the Enter key.

For help creating a comment, see: How to create, edit, and delete a comment in Microsoft Excel.

To use this keyboard shortcut, type text in the cell and when ready for a new line, press and hold down the Alt key, then press the Enter key.

To create a new line on the Mac, use the Control Option Return keyboard shortcut.

To use this keyboard shortcut, type text in the cell and when ready for a new line, press and hold down the Control key, Option key, and Return key.

If youre hunting for,, wondering where is at, or just looking for an easy way to type mathematical symbols, accents and more, weve got you covered.

Youll find QWERTY keyboards for English speakers, while French speakers get a AZERTY keyboard, Germans get QWERTZ, for example.

This means that some guides you will read will talk about an Option or Alt key you cant see on your Mac.

Dont worry though, well let you know what you need to do to type them.

Youll see a range of options appear in a box - just select the one you want or press 5.

But on UK and US keyboard layout the is in a different location.

In fact the location of the on a UK Mac keyboard is different to its location on a US keyboard, just to confuse matters.

If you are in the UK the hashtag sign shares the 3 key with the pound sign () but on other countrys keyboards the UK sign is found else where (well get to that next).

So if you see one or other on the key then pressing AltOption will result in the other key.

To us Mac users this layout makes more sense, we cant imagine why the and would be separated by an expanse of keyboard.

Well mention them here just in case you are struggling to find them.

To type an accented letter all you need to do is press and hold the relevant key.

When you do so a menu will appear with the various accented characters to choose from.

You can choose the version with your pointer, or by pressing the corresponding number.

When you are using a word processor or similar program you can press Control-Command-Space to bring up the Emoji pallet.

It predated Emoji and since Emoji arrived it seems to have been hidden away, but its still there.

Here youll find more than Emoji: there are also Arrows, other currency symbols, Maths Symbols, and more.

If you click on it, you will see options to Show Emoji Symbols and Show Keyboard Viewer.

You can just click on the key as seen on the keyboard on screen.

The app makes it really easy to access the various characters that are available in the different fonts on your Mac.

Can'T Type In Excel For Mac