Microsoft Office; Tips & Shortcuts

prateek99 · 17th June 2010, 12:18

Learning and working on Microsoft Excel and PowerPoint has been one of the greatest things to happen to me, like most of us here.

I am not listing MS Word, as these days most of the reports are prepared in PPT format after the analysis in XLS. (In my two years of experience with a consultancy, only government organizations asked for reports in Word format along with a PPT).

Tips on MS Word are also welcome.

One of the main aspects is to increase the operational speed and reduce the output time, with sleek looking logically presented facts. With proper data analysis and logical presentations, rest assured to turn the tide in your direction.

I am sure there are several champs out here who would love to share their expertise with other members, objective being to share and to improve.
'Pyar aur Knowledge baatne se badhta hai'

No matter how simple the tip is, if someone gets to learn from it, nothing like it.

Like this;

XLSX (I use MS Office 2007);

ctrl+1 gives you pop-up box to format the cell

ctrl+shift+1 converts the number from 1000 to 1,000.00 (this is different from the comma style, it lets you align the content to left or middle)

ctrl+shift+5 converts the number to percentage format

I will share the commands I know as the thread progresses.

Mods; I was unable to find similar thread. Please close the thread if it exists.

amohit · 17th June 2010, 14:48

If you want to insert a newline in the excel cell, press Alt+Enter. Just pressing enter takes you to the new cell.

Superleggera · 17th June 2010, 20:04

Cntrl + ; Gives you the system date
Cntrl + 5 Scratch the contents of the cell

ElantraGT · 17th June 2010, 20:12

Press F4 and it will redo the previious activity that you did. For example, if you had inserted a line, then pressing F4 will insert another line. You can click on another row altogether and continue to press F4 again for adding another line there.

prateek99 · 17th June 2010, 20:21

alt+; selects visible cells only. Lets say if you want to copy visible cells only or delete visible rows only, this is the command.

While deleting the rows make sure you sort the data to reduce the processing load on your processor.

Live To Jive · 25th July 2011, 13:05

I want to upgrade to Office 2010. However I do not want to loose my e-mails, contacts and settings for e-mail. How do I go about doing it.

jaguar.runs · 25th July 2011, 13:38

Great initiative Prateek! Would love to learn new ones and share the ones I know.

Most common ones I use in Excel:

Shift + Space to select a row, Ctrl + Space to select a column. You can add a row/column or insert a copied row/column with Ctrl + + and delete a row/column with Ctrl + -

Alt + = for sum, either for single row/column or multiple row/column. Just select the cells where you need the value before using the short cut.

Ctrl + P to change the font size, Ctrl + F to change the Font.

Guite · 25th July 2011, 15:09

I am a bit confused here. Is Ctrl + P a three key operation? The reason I ask is because I thought Ctrl P (two key operation) is for Print in all MS Windows applications, just like Ctrl S is always Save.

Very useful hints here. I like the F4 shortcut.

jaguar.runs · 25th July 2011, 16:14

Quote:

Originally Posted by Guite

I am a bit confused here. Is Ctrl + P a three key operation? The reason I ask is because I thought Ctrl P (two key operation) is for Print in all MS Windows applications, just like Ctrl S is always Save.

Very useful hints here. I like the F4 shortcut.

@Guite: My bad! I think I was too eager to post

Please read it as Ctrl+Shift+P to change the font size, Ctrl+Shift+F to change the Font.

sfilinto · 7th August 2011, 16:16

This would help all the folks interested in shortcuts.

Keyboard shortcuts in Excel 2010 - Excel - Office.com

Excel Blog - Can

Raja · 9th August 2011, 15:24

Here is a huge article done by PCMag (US):
100 Essential Tips for Microsoft Office 2010 | PCMag.com

IndigoXLGrandDi · 27th September 2019, 00:07

I am facing problem with Excel File while submitting a Tender.

When I download the Excel File (it has .xls extension) of Price Bid, fill the rates, and save the file, my Dell Inspiron 3567 that came with pre-installed version of MS Office Student 2016 gives me Compatibility dialog box. If I click Continue and save the file, this saved file gives me Error while uploading this .xls file on Etendering website.
Error message-
Error in file format. Please upload ConditionsTemp.

If I do this procedure on Office 2010 pirated version (on different laptop), it does not give me Compatibility dialog box and I can upload this .xls saved in Office 2010 on Etendering website without any Error.

How to turn off Compatibility Warning in Office Student 2016?

Jaguar · 27th September 2019, 01:05

Quote:

Originally Posted by IndigoXLGrandDi

I am facing problem with Excel File while submitting a Tender.

When I download the Excel File (it has .xls extension) of Price Bid, fill the rates, and save the file, my Dell Inspiron 3567 that came with pre-installed version of MS Office Student 2016 gives me Compatibility dialog box. If I click Continue and save the file, this saved file gives me Error while uploading this .xls file on Etendering website.

How to turn off Compatibility Warning in Office Student 2016?

Can you share the exact compatibility warning message? And are you sure when you save, it is getting saved as .xls and not in some other format like xlsx?

IndigoXLGrandDi · 27th September 2019, 07:01

Quote:

Originally Posted by Jaguar

Can you share the exact compatibility warning message? And are you sure when you save, it is getting saved as .xls and not in some other format like xlsx?

The following Message gets displayed if I click on Save after editing the downloaded Excel File.
The Type of File in Windows Explorer is shown as Microsoft Excel 97-2003 Worksheet.

Microsoft Office; Tips & Shortcuts-error-excel.png

The Dell Laptop has Windows 10 Home 64-bit and MS Office Student 2016 both License Copies bundled with the Laptop.

I don't get this message on MS Office 2010 (pirated version) on different Laptop-Sony Vaio running Windows 7 32-bit.
Also if I edit that file on MS Office 2010, I can upload that file on the Etendering website without any problem.

Is this related to some problem in MS Office?

EDIT: -
If I manually try to Save as Excel 97-2003 Workbook, I get below message.

Microsoft Office; Tips & Shortcuts-compatibility-message-excel.png

But even this does not allow me to upload the file and throws same error on Dell Laptop with MS Office Student 2016.

turbospooler · 27th September 2019, 10:06

If you are facing higher file size of excel files, try saving them as Binary file.
The below webpage shows how to save it as binary.
https://www.spreadsheet1.com/how-to-...-workbook.html

I have been using binary files an the speed with which the processing occurs also appears to be improved. I was able to save a 80 MB SAP dump as a 4 MB Binary file.

17th June 2010, 12:18	#1
prateek99 BHPian Join Date: May 2010 Location: Pune Posts: 113 Thanked: 20 Times	Microsoft Office; Tips & Shortcuts Learning and working on Microsoft Excel and PowerPoint has been one of the greatest things to happen to me, like most of us here. I am not listing MS Word, as these days most of the reports are prepared in PPT format after the analysis in XLS. (In my two years of experience with a consultancy, only government organizations asked for reports in Word format along with a PPT). Tips on MS Word are also welcome. One of the main aspects is to increase the operational speed and reduce the output time, with sleek looking logically presented facts. With proper data analysis and logical presentations, rest assured to turn the tide in your direction. I am sure there are several champs out here who would love to share their expertise with other members, objective being to share and to improve. 'Pyar aur Knowledge baatne se badhta hai' No matter how simple the tip is, if someone gets to learn from it, nothing like it. Like this; XLSX (I use MS Office 2007); ctrl+1 gives you pop-up box to format the cell ctrl+shift+1 converts the number from 1000 to 1,000.00 (this is different from the comma style, it lets you align the content to left or middle) ctrl+shift+5 converts the number to percentage format I will share the commands I know as the thread progresses. Mods; I was unable to find similar thread. Please close the thread if it exists.
	(1) Thanks

17th June 2010, 14:48	#2
amohit BHPian Join Date: Jul 2007 Location: Bangalore Posts: 451 Thanked: 52 Times	If you want to insert a newline in the excel cell, press Alt+Enter. Just pressing enter takes you to the new cell.
	() Thanks

17th June 2010, 20:04	#3
Superleggera BHPian Join Date: Mar 2007 Location: Kannur/Boston Posts: 531 Thanked: 816 Times View My Garage	Cntrl + ; Gives you the system date Cntrl + 5 Scratch the contents of the cell
	() Thanks

17th June 2010, 20:12	#4
ElantraGT BHPian Join Date: Sep 2009 Location: Chennai Posts: 441 Thanked: 12 Times	Press F4 and it will redo the previious activity that you did. For example, if you had inserted a line, then pressing F4 will insert another line. You can click on another row altogether and continue to press F4 again for adding another line there.
	() Thanks

17th June 2010, 20:21	#5
prateek99 BHPian Join Date: May 2010 Location: Pune Posts: 113 Thanked: 20 Times	alt+; selects visible cells only. Lets say if you want to copy visible cells only or delete visible rows only, this is the command. While deleting the rows make sure you sort the data to reduce the processing load on your processor.
	() Thanks

25th July 2011, 13:05	#6
Live To Jive BANNED Join Date: Jun 2009 Location: Swindon, UK Posts: 698 Thanked: 89 Times	Re: Microsoft Office; Tips & Shortcuts I want to upgrade to Office 2010. However I do not want to loose my e-mails, contacts and settings for e-mail. How do I go about doing it.
	() Thanks

25th July 2011, 13:38	#7
jaguar.runs BHPian Join Date: Jan 2010 Location: Dubai Posts: 277 Thanked: 105 Times View My Garage	Re: Microsoft Office; Tips & Shortcuts Great initiative Prateek! Would love to learn new ones and share the ones I know. Most common ones I use in Excel: Shift + Space to select a row, Ctrl + Space to select a column. You can add a row/column or insert a copied row/column with Ctrl + + and delete a row/column with Ctrl + - Alt + = for sum, either for single row/column or multiple row/column. Just select the cells where you need the value before using the short cut. Ctrl + P to change the font size, Ctrl + F to change the Font. Last edited by jaguar.runs : 25th July 2011 at 13:51.
	() Thanks

25th July 2011, 15:09	#8
Guite BHPian Join Date: Jul 2008 Location: Noida, NCR Posts: 733 Thanked: 629 Times	Re: Microsoft Office; Tips & Shortcuts I am a bit confused here. Is Ctrl + P a three key operation? The reason I ask is because I thought Ctrl P (two key operation) is for Print in all MS Windows applications, just like Ctrl S is always Save. Very useful hints here. I like the F4 shortcut.
	() Thanks

7th August 2011, 16:16	#10
sfilinto BANNED Join Date: May 2006 Location: mostlly bangalore Posts: 102 Thanked: Once	Re: Microsoft Office; Tips & Shortcuts This would help all the folks interested in shortcuts. Keyboard shortcuts in Excel 2010 - Excel - Office.com Excel Blog - Can
	() Thanks

9th August 2011, 15:24	#11
Raja BHPian Join Date: Apr 2007 Location: Pune Posts: 419 Thanked: 69 Times	Re: Microsoft Office; Tips & Shortcuts Here is a huge article done by PCMag (US): 100 Essential Tips for Microsoft Office 2010 \| PCMag.com
	() Thanks

27th September 2019, 00:07	#12
IndigoXLGrandDi Senior - BHPian Join Date: Aug 2009 Location: Solapur (MH-13) Posts: 1,784 Thanked: 566 Times	Re: Microsoft Office; Tips & Shortcuts I am facing problem with Excel File while submitting a Tender. When I download the Excel File (it has .xls extension) of Price Bid, fill the rates, and save the file, my Dell Inspiron 3567 that came with pre-installed version of MS Office Student 2016 gives me Compatibility dialog box. If I click Continue and save the file, this saved file gives me Error while uploading this .xls file on Etendering website. Error message- Error in file format. Please upload ConditionsTemp. If I do this procedure on Office 2010 pirated version (on different laptop), it does not give me Compatibility dialog box and I can upload this .xls saved in Office 2010 on Etendering website without any Error. How to turn off Compatibility Warning in Office Student 2016?
	() Thanks

27th September 2019, 10:06	#15
turbospooler BHPian Join Date: Mar 2013 Location: Pune Posts: 387 Thanked: 1,001 Times	Re: Microsoft Office; Tips & Shortcuts If you are facing higher file size of excel files, try saving them as Binary file. The below webpage shows how to save it as binary. https://www.spreadsheet1.com/how-to-...-workbook.html I have been using binary files an the speed with which the processing occurs also appears to be improved. I was able to save a 80 MB SAP dump as a 4 MB Binary file.
	() Thanks

Thread Tools	Search this Thread
	Search this Thread: Advanced Search