If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
excel-i want it to go to a certain cell when i 1st open the sheet
when i open a spreadsheet that i created, how do i get the cursor to go to
the cell i want it to.. in this spreadsheet i will have to enter information in different columns and i want it to automatically go to the first cell under the first column. how can i do this? |
#2
|
|||
|
|||
excel-i want it to go to a certain cell when i 1st open the sheet
Hi Lindsey,
I can think of two options off the top of my head: 1) Go to the cell, save and close. The next time you open the workbook, the active cell will be the same cell. 2) Use Excel Events. This requires programming Excel using VBA and when done properly can be extremely useful !!! The desired cell will always be the active cell regardless of what cell you are in when you hit save. There are many excellent tutorials on the web (do a google search "excel vba event autoopen"). Here is one link from www.ozgrid.com http://www.ozgrid.com/News/ExcelCust...oRunMacros.htm Excel is an incredible program and it's so much fun learning !!!! Good luck, -- Kevin Lehrbass www.spreadsheetsolutions4u.com "lindsey" wrote: when i open a spreadsheet that i created, how do i get the cursor to go to the cell i want it to.. in this spreadsheet i will have to enter information in different columns and i want it to automatically go to the first cell under the first column. how can i do this? |
#3
|
|||
|
|||
excel-i want it to go to a certain cell when i 1st open the sheet
Lindsey
Right-click on the Excel Icon left of the File command on menu(assuming your window is maximized) and "View Code" If window not maximized r-click on the logo in title bar. Copy/paste this into that module. Private Sub Workbook_Open() Sheets("Sheet1").Select Range("A1").Select End Sub Edit to your sheet name and range. Save and close workbook. Re-open. Gord Dibben Excel MVP On Tue, 13 Dec 2005 13:42:20 -0800, "lindsey" wrote: when i open a spreadsheet that i created, how do i get the cursor to go to the cell i want it to.. in this spreadsheet i will have to enter information in different columns and i want it to automatically go to the first cell under the first column. how can i do this? |
#4
|
|||
|
|||
excel-i want it to go to a certain cell when i 1st open the sh
thank you so much. i have another question. on a drop down box, is there
anyway for the arrow to be "inside" the cell with the drop down list and also for the arrow to be seen? some guy before me created this worksheet and it has drop down boxes where you can see the arrow and it's inside the cell. when i create my drop down box, the arrow only shows up when you get to that cell and it is outside of the cell. i hope this made since "Gord Dibben" wrote: Lindsey Right-click on the Excel Icon left of the File command on menu(assuming your window is maximized) and "View Code" If window not maximized r-click on the logo in title bar. Copy/paste this into that module. Private Sub Workbook_Open() Sheets("Sheet1").Select Range("A1").Select End Sub Edit to your sheet name and range. Save and close workbook. Re-open. Gord Dibben Excel MVP On Tue, 13 Dec 2005 13:42:20 -0800, "lindsey" wrote: when i open a spreadsheet that i created, how do i get the cursor to go to the cell i want it to.. in this spreadsheet i will have to enter information in different columns and i want it to automatically go to the first cell under the first column. how can i do this? |
#5
|
|||
|
|||
excel-i want it to go to a certain cell when i 1st open the sh
Lindsey
"Arrow inside and remains in view". Sounds like a ComboBox from the Control Toolbox Toolbar. Not a Data Validation dropdown. Gord Dibben Excel MVP On Fri, 16 Dec 2005 12:24:01 -0800, "lindsey" wrote: thank you so much. i have another question. on a drop down box, is there anyway for the arrow to be "inside" the cell with the drop down list and also for the arrow to be seen? some guy before me created this worksheet and it has drop down boxes where you can see the arrow and it's inside the cell. when i create my drop down box, the arrow only shows up when you get to that cell and it is outside of the cell. i hope this made since "Gord Dibben" wrote: Lindsey Right-click on the Excel Icon left of the File command on menu(assuming your window is maximized) and "View Code" If window not maximized r-click on the logo in title bar. Copy/paste this into that module. Private Sub Workbook_Open() Sheets("Sheet1").Select Range("A1").Select End Sub Edit to your sheet name and range. Save and close workbook. Re-open. Gord Dibben Excel MVP On Tue, 13 Dec 2005 13:42:20 -0800, "lindsey" wrote: when i open a spreadsheet that i created, how do i get the cursor to go to the cell i want it to.. in this spreadsheet i will have to enter information in different columns and i want it to automatically go to the first cell under the first column. how can i do this? |
#6
|
|||
|
|||
excel-i want it to go to a certain cell when i 1st open the sh
how do you create a combobox with a list of things
"Gord Dibben" wrote: Lindsey "Arrow inside and remains in view". Sounds like a ComboBox from the Control Toolbox Toolbar. Not a Data Validation dropdown. Gord Dibben Excel MVP On Fri, 16 Dec 2005 12:24:01 -0800, "lindsey" wrote: thank you so much. i have another question. on a drop down box, is there anyway for the arrow to be "inside" the cell with the drop down list and also for the arrow to be seen? some guy before me created this worksheet and it has drop down boxes where you can see the arrow and it's inside the cell. when i create my drop down box, the arrow only shows up when you get to that cell and it is outside of the cell. i hope this made since "Gord Dibben" wrote: Lindsey Right-click on the Excel Icon left of the File command on menu(assuming your window is maximized) and "View Code" If window not maximized r-click on the logo in title bar. Copy/paste this into that module. Private Sub Workbook_Open() Sheets("Sheet1").Select Range("A1").Select End Sub Edit to your sheet name and range. Save and close workbook. Re-open. Gord Dibben Excel MVP On Tue, 13 Dec 2005 13:42:20 -0800, "lindsey" wrote: when i open a spreadsheet that i created, how do i get the cursor to go to the cell i want it to.. in this spreadsheet i will have to enter information in different columns and i want it to automatically go to the first cell under the first column. how can i do this? |
#7
|
|||
|
|||
excel-i want it to go to a certain cell when i 1st open the sh
Lindsey
ViewToolbarsControl Toolbox. Click on the "design mode" button. Click on the "combobox" button. Draw a combox box on the sheet. Right-click on the combobox and "Properties" Edit the ListFillRange to the range of items you have listed on a sheet, say A1:A23 Pick a "linked cell" to link your selection to. Set the ListRows to the number items you want to see when you click on the arrow. Hit the "x" to close. Click on the "exit design mode button" and you're good to go. These are the very basics. Adjust and add more functions as you wish. Gord On Tue, 20 Dec 2005 08:26:02 -0800, "lindsey" wrote: how do you create a combobox with a list of things "Gord Dibben" wrote: Lindsey "Arrow inside and remains in view". Sounds like a ComboBox from the Control Toolbox Toolbar. Not a Data Validation dropdown. Gord Dibben Excel MVP On Fri, 16 Dec 2005 12:24:01 -0800, "lindsey" wrote: thank you so much. i have another question. on a drop down box, is there anyway for the arrow to be "inside" the cell with the drop down list and also for the arrow to be seen? some guy before me created this worksheet and it has drop down boxes where you can see the arrow and it's inside the cell. when i create my drop down box, the arrow only shows up when you get to that cell and it is outside of the cell. i hope this made since "Gord Dibben" wrote: Lindsey Right-click on the Excel Icon left of the File command on menu(assuming your window is maximized) and "View Code" If window not maximized r-click on the logo in title bar. Copy/paste this into that module. Private Sub Workbook_Open() Sheets("Sheet1").Select Range("A1").Select End Sub Edit to your sheet name and range. Save and close workbook. Re-open. Gord Dibben Excel MVP On Tue, 13 Dec 2005 13:42:20 -0800, "lindsey" wrote: when i open a spreadsheet that i created, how do i get the cursor to go to the cell i want it to.. in this spreadsheet i will have to enter information in different columns and i want it to automatically go to the first cell under the first column. how can i do this? |
#8
|
|||
|
|||
excel-i want it to go to a certain cell when i 1st open the sh
For more on ComboBox and Data Validation see Debra Dalgleish's site.
http://www.contextures.on.ca/xlDataVal11.html Gord On Tue, 20 Dec 2005 10:32:05 -0800, Gord Dibben gorddibbATshawDOTca wrote: Lindsey ViewToolbarsControl Toolbox. Click on the "design mode" button. Click on the "combobox" button. Draw a combox box on the sheet. Right-click on the combobox and "Properties" Edit the ListFillRange to the range of items you have listed on a sheet, say A1:A23 Pick a "linked cell" to link your selection to. Set the ListRows to the number items you want to see when you click on the arrow. Hit the "x" to close. Click on the "exit design mode button" and you're good to go. These are the very basics. Adjust and add more functions as you wish. Gord On Tue, 20 Dec 2005 08:26:02 -0800, "lindsey" wrote: how do you create a combobox with a list of things "Gord Dibben" wrote: Lindsey "Arrow inside and remains in view". Sounds like a ComboBox from the Control Toolbox Toolbar. Not a Data Validation dropdown. Gord Dibben Excel MVP On Fri, 16 Dec 2005 12:24:01 -0800, "lindsey" wrote: thank you so much. i have another question. on a drop down box, is there anyway for the arrow to be "inside" the cell with the drop down list and also for the arrow to be seen? some guy before me created this worksheet and it has drop down boxes where you can see the arrow and it's inside the cell. when i create my drop down box, the arrow only shows up when you get to that cell and it is outside of the cell. i hope this made since "Gord Dibben" wrote: Lindsey Right-click on the Excel Icon left of the File command on menu(assuming your window is maximized) and "View Code" If window not maximized r-click on the logo in title bar. Copy/paste this into that module. Private Sub Workbook_Open() Sheets("Sheet1").Select Range("A1").Select End Sub Edit to your sheet name and range. Save and close workbook. Re-open. Gord Dibben Excel MVP On Tue, 13 Dec 2005 13:42:20 -0800, "lindsey" wrote: when i open a spreadsheet that i created, how do i get the cursor to go to the cell i want it to.. in this spreadsheet i will have to enter information in different columns and i want it to automatically go to the first cell under the first column. how can i do this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Clicking Cell Link Changes Cell on Another Sheet | nshah | General Discussion | 1 | August 31st, 2005 01:50 AM |
How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | nwtrader8 | General Discussion | 5 | June 21st, 2005 02:16 PM |
In Excel Sheet how I can give Number bullets in the series of cell | Alpesh Patel | General Discussion | 4 | October 8th, 2004 10:14 PM |
A way to open an Excel sheet from Word | Tonya Marshall | New Users | 3 | August 24th, 2004 10:17 AM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |