Need Quick Excel Help? Have a question that needs to be answered? Looking for a quick VBA code/book/ add in/or template?
Excel General
Create a drop-down list from a range of cells
Submitted by Support on Sun, 06/29/2008 - 16:23.To make data entry easier, or to limit entries to certain items that you define, you can create a drop-down list of valid entries that is compiled from cells elsewhere on the worksheet.
Image:
Delicious
Digg
StumbleUpon
Propeller
Reddit
Furl
FacebookMove, delete or copy a toolbar button quickly
Submitted by Support on Sun, 06/29/2008 - 14:50.To customise our toolbars, we generally need to enter Customize mode. However, we can move or copy toolbar buttons without enabling Customize mode.
Selecting a Range of Non-Adjacent Cells
Submitted by Support on Mon, 06/16/2008 - 15:45.To select a range of non-adjacent cells:
1. Select cell A1, and press Ctrl+Shift+Down Arrow.
2. Continue holding down Ctrl, and select another range.
Image:
Using keyboard shortcuts
Submitted by Support on Mon, 06/16/2008 - 15:42.The Current Region/List is a range of cells containing data bounded by blank rows and columns.
To select the Current Region/List:
Image:
