Question about Microsoft Computers & Internet

1 Answer

Closing Worksheet on executing Hyperlink command

I use Excel 2003. I created worksheet A where there is a link to another worksheet B. After studying worksheet B,
I again move to Worksheet A using Hyperlink command and address of Sheet A.
My requirement is that sheet should close on execution of hyperlink.

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 407 Answers

You could do this by creating a close button with the worksheet- Do this via insertin ga prompt in Macro.

Posted on May 22, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

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

Tip

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


Hello everybody, this would be my first tip on FixYa.com. 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

1 Answer

How many charts can put in a sheet?


194a9e0.jpg

In Microsoft Excel 2003 for PC, you may add at least 32 charts as as objects into a worksheet (as illustrated above), however it appears that you may add as many charts as you wish into a worksheet using this method .

Dec 10, 2009 | Microsoft Excel 2003 (06503995)

3 Answers

How can enable mail recipient as attachment excel


MAIL RECPEINT AS ATTECHMENT OPTION NOT VISIBLE IN MY OFFICE 2003 PROFESSIONAL

Apr 11, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

I have worksheet one & worksheet 2. I want to compare the data from worksheet 1 to worksheet 2 but some of the data from worksheet 1 are not available in worksheet 2. How do i do that?


depends on your version of Excel

2003 - unfortunately not so apparent - easiest copy one worksheet to another (new) workbook then go to Window>>Compare Side by Side with option (while both workbooks are open)

2007 - on the Window section of the View tab - click New Window then View Side by Side icon (next to Split) - you may have to arrange the two windows to be side by side as it may come up one on top of the other (click on Arrange All in the Window section to choose Vertical vs. Horizontal)

Mar 26, 2009 | Computers & Internet

1 Answer

Automatically creating a new worksheets


You can not do it by formulea but there is something called as ***-in you need to create add -in for this

I will suggest you that get a small program for doing this which will do all buisiness processing automatically will give you lots of benifits such as notification error catching and all.

If you need anything else,let me know.

Dec 17, 2008 | Microsoft Office Excel 2003 for PC

1 Answer

Print area in worksheet


1. Select area you want to print.

2. When you click Print, you getting Print window.
In "Print what" frame choose "Selection" option.

Sep 17, 2008 | Microsoft Office Professional 2007 Full...

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

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'

Nov 29, 2007 | Microsoft Excel for PC

2 Answers

EXCEL


It is very useful to learn excel shortcut realy i thank you

Sep 26, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

162 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18333 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...