Go Around The Tech Corner…

Posts Tagged ‘excel

If you’re making a document using Microsoft Excel, you can easily change the direction of the text appearing in the cells, by rotating it to any angle. The default orientation of text is horizontal, but you can choose to display your text either vertically or to a certain angle. This is how it is done:

First select the cell(s) which holds the text you want to rotate. Then right click that cell and click on ‘Format Cells’. This brings up the Format Cells dialog box, which you normally use to specify the kind of data you want to key in – e.g. date formats, or currencies. On this dialog box, click on the ‘Alignment tab’. Here you’ll see that under the orientation section, you’ll be able to change the direction of the text according to the number of degrees you want it to be rotated. Change it to your requirements and click ‘OK’ to close the dialog box.

Formatting text in Office Software is very easy as Microsoft provides a user-friendly environment. You just have to know to manipulate your content and you can have your documents looking good in seconds!

From next week I’ll be dishing out tips on the programming side now. From HTML to CSS to Visual Basic. If you want to know anything from these topics, do let me know and I’ll write about it!

– Millie

Advertisements

When you’re working with sensitive documents, you can set passwords to the document so that no one else gets access to them, unless they have the password. Microsoft Office provides the passwords feature for all types of files: Word, Excel, PowerPoint, Access, Publisher etc. This is how you can set a password to your documents:

Open the document, then from the File menu, click on ‘Save As’ to bring up the Save As Dialog box. Once you specify the location of where you want the file to be saved, click on the tools menu on that dialog box and go to ‘General Options’. In the General Options box, you can set a password to open the file and you can also set a password (different or same) for modifying a file. Passwords can be up to 15 characters max.

Once both the passwords have been set, click ‘ok’. Then you’ll see another dialog box which will prompt you to confirm the passwords. Enter the correct passwords again and click on ‘ok’. This closes the extra boxes and you’re left with the ‘Save As’ dialog box, where you’d started. Now click on ‘Save’. That’s about it.

Now if you try and close and re-open the file, it will ask you for the passwords before you can get access to your data. This is the best way to protect your files from unauthorized access, especially if you’re sharing your computer with someone else.

Hope this tip has been helpful!

Cheers,

Millie


Me – The author of this blog!


This is my tech blog. I got another blog, full of jokes that will crack u up! http://humoraddict.blogspot.com

Follow milliepatel84 on Twitter

Tweet Tweet…!!!!

Blog Stats

  • 43,913 hits

Top Clicks

  • None

Flickr Photos

%d bloggers like this: