Excel Tips

Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts

Monday, April 20, 2009

Toggle Between Relative and Absolute References

Use the function key F4 to toggle a reference between relative and absolute references while editing a formula. Repeatedly pressing F4 will cycle through the 4 different options in this order: A1, $A$1, A$1, $A1.
Read more »
No comments :
Older Posts Home
Subscribe to: Posts ( Atom )

Popular Posts

  • Insert a New Row or Column - Excel Keyboard Shortcut
  • Keyboard Shortcuts to Insert Special Symbols in Excel
  • Quickly Fill Multiple Cells with a Value or Formula
  • Square Cells in Excel
  • Round to the Nearest Multiple Other Than 10
  • Return the Last Numeric Value in a Column
  • Dynamic Print Area in Excel
  • Use the OFFSET Function for a Running Balance
  • Return the Last TEXT Value in a Column

Categories

  • arrays ( 1 )
  • charts ( 1 )
  • customizing ( 2 )
  • drawing ( 1 )
  • Excel ( 1 )
  • formatting ( 3 )
  • formulas ( 4 )
  • functions ( 1 )
  • lookup ( 2 )
  • navigation ( 1 )
  • options ( 1 )
  • printing ( 2 )
  • shortcuts ( 6 )
  • tricks ( 5 )

More Excel Tips

  • Vertex42 Excel Tips
  • Allen Wyatt's Tips
  • ExcelTip.com
  • J-Walk.com
  • Daily Dose of Excel
Powered by Blogger.