Excel Tips – How to Quickly Edit Formulas And Data In Multiple Cells in Excel 2010


Excel Tips  How to Quickly Edit Formulas And Data In Multiple Cells in Excel 2010 In this tutorial we will cover two tips: how to quickly edit formulas, and also how to quickly edit data in multiple cells, all in Excel 2010. How to Quickly Edit Formulas  I am sure once you see this tip you will find lots of uses for it. In typical worksheets, there is a great deal of consistency in formulas. They are usually identical in structure, differing only in the actual cells they are referencing within the spreadsheet. But when it comes to relative referencing, most formulas are identical. For example, =SUM(G1:G50) and SUM(H1:H50) are really SUM(the first row in this column to the cell immediately above this formula). When you create worksheets that have formulas with identical structures, it makes copying and editing and understanding your formulas a whole lot easier. To copy a formula, most Excel users type the first formula, then copy and paste it to the other cells. Same goes for editing
http://bit.ly/1O90cpX

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s