Question about Computers & Internet

1 Answer

Hello, in Excel, I want to key in a specific number (1015899) and link to a PTF file of a Certificate, which would be printed. All of the Certificates would have been scanned into the computer, each named by a specific number for a match up when you key in that number.

Posted by on

  • rkerwin1 Sep 08, 2010

    Hello again, the solution provided does not address the problem. I believe you are suggesting a list of the various numbers and each one hyperlinked to the respectful ptf file.
    What I would like is to have 1 cell where I key in any of the various numbers (might be as many as 400 numbers) and the corresponding matching number ptf file appears. (which is an inspection certificate) Also, I would like to be able to go back to the original screen and key in another number if need be. Please help

×

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 22 Answers

Go to insert and click the hyperlink button. It will popup a box with the text you want the link to say and a folder browsing window for directing to the files you are referring to. Highlite the numbered ptf file you want to link to and you are set.

Posted on Sep 07, 2010

  • S1LV3R
    S1LV3R Sep 08, 2010

    What you are attempting to do is a database type of lookup or a edit-able pivot table. Do you know how to make a pivot table or make a database of sorts for querying?

  • S1LV3R
    S1LV3R Sep 09, 2010

    Well ok, thanx for the one thumb i guess. Sorry i couldnt help you.

×

Ad

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.
Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

Size of the excel file increased from 721 KB to 50MB


Many businesses use Excel to track their data and expenses.
However, you can run into problems when files grow too big.
Try reducing the size of your Excel files in different ways to eliminate your storage problems.
Remove unnecessary graphics and fonts from the Excel file.
Simple report data doesn't need a lot of excess formatting to make it attractive.
If you need to keep different fonts in your file, reduce some of the font sizes you originally used.
Reduce the number of pivot tables you allow in your data analysis.
Run your pivot table wizard when dealing with involved calculations.
When given options to format the file, choose those that allow the data to refresh instead of adding a new table.
Input your data, close the file and save as an Excel (XLS format) file and as an HTML (XML format) file.
To do this, choose "XML Data" in the "Save as type" drop down box.
Change the name of your document as well, so you can tell the difference between the two files.
Open the XML file and save it back into the regular XLS file to create a smaller file than the original.
Again, rename this file, as well as changing its type. This act removes odd programming left from past calculations since the last "save."
Check into file compression software such as OzGrid.
These products exist because you cannot open a file once it gets too big.
Compress the XLS data by compelling the program to recalculate the cells used for your file.

Excel File Size Reduce Software 7.0
http://www.newfreedownloads.com/Business/Spreadsheets/Excel-File-Size-Reduce-Software.html

http://www.ozgrid.com/

or

Microsoft Excel files can contain thousands of cells filled with data.
When you combine this information with graphics, such as charts and graphs, as well as ever-expanding links to other worksheets, you can end up with an enormous file that takes up precious system space and slows Excel down.
While there are many software programs available that promise to shrink Excel files, there are many ways to reduce the bulk without downloading a new application.

1. Click on any cell in the Excel file you want to reduce.
Open the "Go To" dialog box in Excel 2007 by clicking the "Find" drop-down arrow on the Home tab of the ribbon and selecting "Go To."
In Excel 2003 or earlier, go to the "Edit" menu and select "Go To."
You can also use the keyboard shortcut "Ctrl+G" in any version of Excel.
2. Click the "Special" button on the "Go To" dialog box.
Select "Blanks" and click "OK." Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All." This will clear any blank cells to help reduce the file size.


3. Go to the very last cell containing data in the Excel file.
Select the entire row beneath this cell by clicking the number to the left of it.
Hold "Ctrl+Shift" and then press the down arrow key to select all of the cells beneath this point.

4. Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All."
Select the column to the right of the last cell. Hold "Ctrl+Shift" and then press the right arrow key. Again, select "Clear All."
5. Repeat Steps 1 through 5 for any other Excel files that are linked to the workbook you are trying to reduce.
Save the files and then check the new file size by clicking the "Office Button" in Excel 2007.
Point to "Prepare" and then click on "Properties." In Excel 2003 or earlier, go to the "File" menu and select "Properties."
The file size will be listed on the "General" tab.



http://www.ozgrid.com/Excel/ExcelProblems.htm

Apr 22, 2013 | Microsoft Office Professional 2010

Tip

Microsoft Excel tips


Auto sum shortcut key
Quickly create a Microsoft Excel formula to get the sum of all cells by highlighting the cells you wish to know the value of and pressing ALT and = .
Create hyper links in Excel
Quickly create hyper links in your Microsoft Word, Excel, or Front Page document by highlighting text and pressing "CTRL + K".
Close all open files at once
Close all open Microsoft Word and/or Excel files by holding down the shift key and clicking "File" and then "Close All".
Quickly open recently opened files
Quickly open the recent files by first pressing "ALT + F" to open the file Menu and press 1, 2, 3, or 4.
Create underlines without any text
This tip works with the majority of Microsoft Office applications. Easily create an underlined space by pressing CTRL + U to start the underline, then press SHIFT + Space for each underlined space you wish to create. An example of how this could be used is for printable forms, for example: Name: .
Print only sections of a document
Save on your printer ink by selectively printing in Windows programs such as Microsoft Word, Internet Explorer, WordPad, Outlook, etc. To do this highlight portions of text you wish to print and click print. In the printer dialog window under Page Range choose the option Selection. It is important to realize that not all programs or printer drivers support this feature.
Repeat recent action
Using the F4 key in Microsoft Office 2000 and above allows the user to repeat the last used action. For example, if you have changed the font of a selected text and wish to change another portion of text to the same font, pressing F4 will do this for you automatically.
Quickly undo
Quickly undo mistakes in the majority of most PC Windows program by pressing CTRL + Z.
Quickly above cell contents
In Microsoft Excel press CTRL + SHIFT + " to copy the above cells contents.
Using the Microsoft Excel Auto filter
Organize cells quickly by using Microsoft Auto filter. Columns that contains long listing of data can be easily sorted by using the Auto filter option, to use this option select the top rows of the columns you want to be used and select Data / Filter and Auto Filter. Once successfully completed you can use drop down arrows to filter the data automatically.

on Dec 27, 2009 | Computers & Internet

1 Answer

Reduce the size of excel file


Many businesses use Excel to track their data and expenses.
However, you can run into problems when files grow too big.
Try reducing the size of your Excel files in different ways to eliminate your storage problems.
Remove unnecessary graphics and fonts from the Excel file.
Simple report data doesn't need a lot of excess formatting to make it attractive.
If you need to keep different fonts in your file, reduce some of the font sizes you originally used.
Reduce the number of pivot tables you allow in your data analysis.
Run your pivot table wizard when dealing with involved calculations.
When given options to format the file, choose those that allow the data to refresh instead of adding a new table.


Input your data, close the file and save as an Excel (XLS format) file and as an HTML (XML format) file.
To do this, choose "XML Data" in the "Save as type" drop down box.
Change the name of your document as well, so you can tell the difference between the two files.

Open the XML file and save it back into the regular XLS file to create a smaller file than the original.
Again, rename this file, as well as changing its type. This act removes odd programming left from past calculations since the last "save."
Check into file compression software such as OzGrid.
These products exist because you cannot open a file once it gets too big.
Compress the XLS data by compelling the program to recalculate the cells used for your file.


Excel File Size Reduce Software 7.0
http://www.newfreedownloads.com/Business/Spreadsheets/Excel-File-Size-Reduce-Software.html

http://www.ozgrid.com/
or
Microsoft Excel files can contain thousands of cells filled with data.
When you combine this information with graphics, such as charts and graphs, as well as ever-expanding links to other worksheets, you can end up with an enormous file that takes up precious system space and slows Excel down.
While there are many software programs available that promise to shrink Excel files, there are many ways to reduce the bulk without downloading a new application.

1. Click on any cell in the Excel file you want to reduce.
Open the "Go To" dialog box in Excel 2007 by clicking the "Find" drop-down arrow on the Home tab of the ribbon and selecting "Go To."
In Excel 2003 or earlier, go to the "Edit" menu and select "Go To."
You can also use the keyboard shortcut "Ctrl+G" in any version of Excel.
2. Click the "Special" button on the "Go To" dialog box.
Select "Blanks" and click "OK." Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All." This will clear any blank cells to help reduce the file size.


3. Go to the very last cell containing data in the Excel file.
Select the entire row beneath this cell by clicking the number to the left of it.
Hold "Ctrl+Shift" and then press the down arrow key to select all of the cells beneath this point.

4. Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All."
Select the column to the right of the last cell. Hold "Ctrl+Shift" and then press the right arrow key. Again, select "Clear All."
5. Repeat Steps 1 through 5 for any other Excel files that are linked to the workbook you are trying to reduce.
Save the files and then check the new file size by clicking the "Office Button" in Excel 2007.
Point to "Prepare" and then click on "Properties." In Excel 2003 or earlier, go to the "File" menu and select "Properties."
The file size will be listed on the "General" tab.



http://www.ozgrid.com/Excel/ExcelProblems.htm

Apr 22, 2013 | Microsoft Office Computers & Internet

1 Answer

When i install a sis or sisx file..it always say file corrupted!! can you help me with this?


for showing certificate error problem.......
>download from website signtools3.23
and open this software
>1.select the specific software whatever u want to unsign
>2.select the certificate file(that will available insigntools software)
>3.select the key file(that will available insigntools software)
>then signature it

Jul 27, 2012 | Nokia N95 Smartphone

1 Answer

I have Windows 7 op sys in my HP computer. My HP L7680 will now not print an Excel file on legal--reduces the size to letter. Help!


Software issue. Contact MS since HP will do nada for you since it is not a printer problem. Maybe your excel program is not really compatible with Win 7. Check it out.

Aug 23, 2017 | HP Officejet Pro L7680 All-In-One Printer

1 Answer

My printer does no print for excel file


Hello kushivijay1

Try this.
Open a new excel worksheet and type in Just one or two words or numbers and try to print that sheet. Make sure the correct printer is selected - that is if you have other printers in the list shown in the printer menu- also the correct paper is selected.
If this test is successful, then you have to examine the other excel files which failed to print. Chances are you have the wrong printer selected.

Good luck
luciana44

Feb 25, 2010 | Samsung ML 1710 Laser Printer

1 Answer

I cant print word documents. It says printer is


I have encountered this problem, wherein I can print webpages, excel, pdf files, but not in Microsoft Word.

I received error "Windows cannot print due to a problem with the current printer setup".

I got it resolved by following the instructions given by Microsoft: http://support.microsoft.com/kb/826862

Specifically the steps under 'Delete the Word Data key'.

Oct 14, 2009 | Office Equipment & Supplies

1 Answer

Invoice & Order Minimize Data Entry - Especially Name and Address


Do you have Microsoft Access? If so, you could use that to create a database and an invoice form. You could also use Access to "dump" the info into Excel to track and record.

Otherwise, try searching for "Import Data" in the Excel help. It would be very difficult to walk you through the whole process, but if you have specific questions about certain steps, that would be more manageable.

Jan 06, 2009 | Microsoft Excel for PC

2 Answers

Minimize Data Entry


I will suggest you to create small application in .net for ths which will add some value and process your data;If you want to use Excel only make a master sheet with details and use it in other excel sheets

Jan 02, 2009 | Microsoft Excel for PC

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

Related Topics:

28 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

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

Answer questions

Manuals & User Guides

Loading...