Ron Mikhael Surara

Ron Mikhael Surara

Friday, January 9, 2015

What I Learned in CompSci #22: Tips

Tips in Excel

1. Alt + Enter - Adds a new space

2. Ctrl + ; - Inputs the current date

3. Ctrl + Shift + ; - Inputs the current time

4. Ctrl + Enter - Inputs the same data into multiple cells

5. Check "Advanced Options" - It could save you

6. To have uniform row/column length, select the columns/rows then adjust one of them

7. To add a password, just save, at the save/save as dialogue box click tools, then click 
General Options, fill in, click ok, then ta-da! Your file already has a password, you can also check the backup in case someone gets annoyed by the password and deletes it



Reference: http://travelmanagement.yale.edu/sites/default/files/images/Helpful%20Tips.jpg
http://moodle.pshs-brc.edu.ph/pluginfile.php/4705/mod_resource/content/0/Spreadsheet%20for%20Data%20Analysis.pdf