Question about Microsoft Excel for PC

1 Answer

Microsoft Excel How to go from one worksheet to another worksheet in excel without using mouse.

Posted by on

1 Answer

Re: Microsoft Excel

Dear jois you can make a link from one sheet to other sheet by making a hyperlink. When you will click one cell in first sheet it would shift the sheet in the cell you will fix it.

You can follow this process:

  1. Select a cell that contains the external formula
  2. Highlight the File path and sheet name in the Formula bar, eg; 'L:\Daves\[Book2.xls]Sheet1'!
  3. Push Ctrl+C then push Enter.
  4. Select the range of cells you wish to change the reference in and go to Edit>Replace.
  5. Select in the Find what box and hold down the Backspace to ensure you do not have a space.
  6. Push Ctrl+V.
  7. Do the same in the Replace with box and then edit the file path to the new one needed.
  8. Click Replace All
if that has helped you please press 'fixya'

Posted on Nov 29, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

4 Answers

Excel sheet has been lost how to recover

Lost Excel file can be recovered from:
  1. Recycle Bin - If you have deleted the file with normal delete.
  2. Backup - If have maintained the backup of file.
  3. Email - It may possible that you have mailed the file to someone.
  4. 3rd Party Recovery Software - Recuva, Stellar Data Recovery ...

Oct 29, 2012 | Microsoft Office Excel (License Only)...


How to find no. of rows and columns in Worksheet.

Hello everybody, this would be my first tip on Number of people might not be aware how many rows and columns are there in Microsoft Worksheet.
This is how you can find out.
1. Select A1 cell in the worksheet
2. Now press Ctrl + down arrow from your keyboard, that will take you to the bottom of the row. You can find the number on the left side.
3. Again select A1 cell in the worksheet and press Ctrl + left arrow from your keyboard, that will take you to the last column of the worksheet. Now to number, just type "=column() " , without quotations, that will give you the number of the column.
Microsoft Worksheet columns is number from A to Z, again from AA to AZ, again from BA to BZ and so on till it reached IV in Excell 2003 and earlier version.
Microsoft Excel 2003 and old version has 16,777,216 cells per worksheet (65,536 rows * 256 columns).
Excel 2007 has 17,179,869,184 cells per worksheet (1,048,576 rows * 16,384 columns).

on Jul 27, 2010 | Microsoft Excel for PC

2 Answers

What is a workbook?

A workbook is a spreadsheet file. By default, each workbook in Excel contains three pages or worksheet

The term spreadsheet is often used to refer to a workbook, when in actual fact, spreadsheet refers to the computer program, such as Excel.

So, strictly speaking, when you open the Excel spreadsheet program it loads an empty workbook file consisting of three blank worksheets for you to use.

Jun 25, 2011 | Microsoft Office Excel 2007 Full Version...

1 Answer

What is default name in ms excel? how is possible excel worksheet in excel?

Book1.xls Do you mean that you can't find the worksheet you have establish and you haven't rename the file? The worksheet will be OK if it had been saved.

Feb 15, 2011 | Microsoft Office 2010

1 Answer

What is the formulas in computing grades in excel?

Deeply repair Excel file password and unlock Excel spreadsheet with use Microsoft Excel unlocker password software. You can simply use this software which completely crack Excel sheet password and excel users very easily read Excel worksheet without any trouble.More information-:

Aug 16, 2010 | Microsoft EXCEL 2004 for Mac

2 Answers

Worksheet protection password hacking

You should download Excel Password Recovery, take a look to you can download it.

Mar 02, 2009 | Microsoft Office 2003 Basic Edition...

1 Answer

Merging problem

Use the Help function in excel and search for "Consolidate". This will show you how to consolidate data from multiple worksheets into one worksheet.

Feb 19, 2009 | Microsoft Excel for PC

2 Answers

Import data from access into excel where one column go into one worksheet and other into next

Can't be done.

Access will only put the data into one worksheet. It is very picky when it comes to exporting data into an Excel spreadsheet.

There are two ways to get around it:

1) You can export the data from Access into two files. One for the the first worksheet and another file for the second workshet.

2) You can import everything into one spreadsheet and build a macro into Excel to cut the information one spreadsheet and paste it into the other if this is a redundant task to do all the time.

Hope that helps you out.

Jun 10, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Export data in excel shld yoeet through VB

When i first figured out how to pull data from SQL and put the results in an excel file i referenced these two articles....
Reading and writing excel file using VB.NET (
Get the Values From DataBase and Stored into excell Sheet (

This is the code i ended up using.... (check out those links to see how you need to import the ms office excel reference file with visual basic)

Const stcon As String = "Provider=SQLNCLI;server=xxxxx;database=xxxxx;uid=xxxxx;pwd=xxxxx;DataTypeCompatibility=80"
Dim stSQL As String = "select * from scs_rate_class_money where irate_book = 124 and snew_used = 'U' and sclass = '2' and splan = 'T4' and sopt_code = 'F1'"
Dim cnt As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim fld As ADODB.Field
'Open the connection.

'Open the recordset.
With rst
.CursorLocation = ADODB.CursorLocationEnum.adUseClient
.Open(stSQL, cnt, ADODB.CursorTypeEnum.adOpenForwardOnly, _
ADODB.LockTypeEnum.adLockReadOnly , _
.ActiveConnection = Nothing 'Disconnect the Recordset.
End With
'Close the connection
cnt.Close ()
Dim exp As Export = New Export()
Dim xlApp As New Microsoft.Office.Interop.Excel.Application
Dim xlWBook As Microsoft.Office.Interop.Excel.Workbook = xlApp.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet )
Dim xlWSheet As Microsoft.Office.Interop.Excel.Worksheet = CType(xlWBook.Worksheets(1), Microsoft.Office.Interop.Excel.Worksheet)
Dim xlRange As Microsoft.Office.Interop.Excel.Range = CType(xlWSheet, Microsoft.Office.Interop.Excel.Worksheet).Range("A2")
Dim xlCalc As Microsoft.Office.Interop.Excel.XlCalculation
Dim i As Short

'Turn off Excel's calculation.
With xlApp
xlCalc = .Calculation
.Calculation = Microsoft.Office.Interop.Excel.XlCalculation.xlCalculationManual
End With
'Write the fieldnames.
For Each fld In rst.Fields
xlRange.Offset(0, i).Value = fld.Name
i = i + 1
'Populate the range.
xlRange.Offset(1, 0).CopyFromRecordset(rst)
'Close the recordset.
'Make Excel available to the user.
With xlApp
.Visible = True
.UserControl = True
'Restore the calculation mode.
.Calculation = xlCalc
End With
'Release variables from memory.
fld = Nothing
rst = Nothing
cnt = Nothing
xlRange = Nothing
xlWSheet = Nothing
xlWBook = Nothing
xlApp = Nothing

Jan 03, 2008 | Business & Productivity Software

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

104 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides