Archives for MS Office
Hub Spoke diagram in Visio
On the File menu, point to New, point to Business, and then click Marketing Charts and Diagrams. From Marketing Diagrams, drag a Circle-spoke diagram shape onto the drawing page. Choose…
Reduce size of excel workbook
Excel uses a lot of space with empty cells. There isn’t an easy way to figure out how much space is being wasted. I was seeing an Excel file at…
Outlook password change not picked up by iPhone client
I recently changed my outlook 365 password - and was unable to get my iPhone mail client to pick up the new password. Here are a few things I Step…
Converting from DD-MM-YYYY to YYYY only in excel
Lately, I needed to go through a column full of dates – in the format MM-DD-YYYY. The thing is , I didn’t care for the day or the month of…
Creating and Using Drop Down lists in Excel
Using the drop down list values in a cell In the Cell, Click Data >Data the Settings tab, in the Allow box, click List. In the Source box, type and…
Add single quotes around values in excel column
Go to Format –> Cells –> CustomType '@'
Hide gridlines in Excel
Select multiple sheets , On the View tab, in the Show/Hide group, check/uncheck the Gridlines check box.
Word 2010 Pictures do not show up
I pasted pictures into my documents – only to find that they did not display. It turns out that it has to do with the default wrapping style on…
Deleting a large number of pages in Microsoft word
What I wanted was to be able to select a few pages (say pages 1 through 3 – and DELETE everything ELSE – – INVERT The selection. Unfortunately, amongst all…
Take an existing PPT theme and apply it to another presentation
I don’t know why Microsoft has to change things around completely with every new release of MS Office. However, if you have an existing MS PPT 2010 presentation – and…