Shortcut for Switching from a Relative Reference to an Absolute Reference

Post Your PC Questions

Site Index | Quick Index | New Tips | MS Windows | MS Office | Newsletter | Q&A | More Tips |

Tips Download | Donations | Customer Support | Registry Tips | Weekend Windup | IE 6.0 | IE 7.0 | Help | Suggestions

Windows XP Run Commands | Computer Questions. | Microsoft Access Databases | Computer Terms | New Home Material Estimating Spread Sheets!

Windows XP Remote Desktop Setup One! | 57 Vista Run Commands | Windows XP Remote Desktop Setup Two!

See The 11 Tip Package That You Should Print And Keep Close To Your Computer!

100 Vista Tips!

This One Comes With The Standard Tips Package! Two Downloads!

Internet Fixes Computer Related FAQ. News Feed TOP 10 Questions Feed My Blog!

Shortcut for Switching from a Relative Reference to an Absolute Reference

You can press F4 to toggle the relative and absolute cell address for a formula. When you type a formula in the formula bar, use a cell reference in relative address form (for example, use A1). After you type the reference, press F4 and the cell reference is automatically changed to an absolute cell reference (for example, $A$1). You can also continue to press F4 to display mixed absolute and relative reference forms. For more information about cell referencing, click the Find tab in Microsoft Excel Help, type the following text

absolute and relative

and then double-click the "The difference between relative and absolute references" topic.

<<<Back Home Next>>>

Hit Counter

Main Site Navigation:

See The 11 Tip Package That You Should Print And Keep Close To Your Computer!

100 Vista Tips!

This One Also Comes With The Standard Tips Package! 2 Downloads!

Internet Fixes Computer Related FAQ. News Feed TOP 10 Questions Feed My Blog!
Newsletter Signup | Search | Windows Versions | Office Versions | Forum | Readers Q&A | Tips In Full Graphics | Tips Download

Site Navigation:
Donations | Support | Registry Tips | Weekend Windup | PC Questions | IE 6.0 | IE 7.0 | Outlook Express 6.0 | PC Help
Virus Info | Computer Drivers | Hardware Info. | Your Suggestions | IE 7.0 Install | Database Downloads | Home | Computer Terms

| 57 Vista Run Commands | Windows XP Run Commands | Microsoft Access Databases |

Windows XP Remote Desktop Setup One! |New Home Material Estimating Spread Sheets!| Windows XP Remote Desktop Setup Two!

All products mentioned are registered trademarks or trademarks of their respective companies.
Questions or problems regarding this web site should be directed to the Webmaster.
Copyright © 1999-2008 Internet Fixes. All rights reserved. Legal Disclaimer

This Site Is Part Of The Internet Fixes Network!