Posts Tagged ‘Word’


UntitledAlthough Excel is a primarily a spreadsheet program, which means that it has been designed to store numbers, we often need to use some cells to store text. Also, at times we need to use ‘Word’-like features like line breaks or bullet points. Did you know that you could achieve it in Excel this way:

For bullet points – use [Alt] + 7 or [Alt] + 9 key from the numeric keypad on your keypad. The former combination will give you a filled-in bullet and latter will give you an empty bullet. In laptops where there is no dedicated keypad, use the [Fn] + [Num Lock] or [Shift] + [Num Lock] key to enable the numeric keypad and then use the shortcut for bullets.

Bullets Points in Excel Cells

Bullets Points in Excel Cells

For line breaks, use [Alt] + [Enter] key

Line Breaks in Excel Cells

Line Breaks in Excel Cells

 

Addendum:

Using [Alt] + any number from the numeric keypad inserts the character associated with that ASCII code. In the above case, it’s the two circles.

 

 

Advertisements

UntitledWhen we create presentations Powerpoint, we spend quite a lot of time in getting the look and feel right. Among other things, this involves applying similar formats to all shapes and pictures. In my experience, shapes are the trickiest part. There is so much customisation and so many options to do so, that there is a chance that a few parts may be missed in some shapes.

To avoid this, you can set defaults. To do so, insert a shape (any of the available ones), apply formatting changes that you want – fill color, shape outline, shape effects, shape style, etc. When you are sure that you have the look of the shape right, right click on the shape and select ‘Set as Default Shape‘. (more…)