Hey,

I'm creating a contact sheet at the moment and I want 5 columns and 2 rows, this is all fine except the pictures could be bigger. The margins between the pictures seem very big, how can I make them smaller so that in turn the pictures will be bigger?

Ad

How much? program install Adobe photoshop

Posted on May 15, 2008

Ad

Just click on zoom butten.

Posted on Mar 15, 2008

Ad

Hi there,

Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

create an additional sheet in worksheet at the bottom of worksheet is a +

add a sheet put each merchandise code in each row going down the column worksheet.

in the next row put the name beside the matching code.

then when finished sort on both columns using the merc, code to sort ascending.

notice in the next picture the addition of $ in the row

this is done to allow you to copy down the formula and leave the reference array the same

look at bottom of spread sheet to see additional sheet being used called code to create the array for the look up. With more array rows just modify the formula to say =lookup(a2,codes!$a$1:$b$200)

lookup will give you a text answer where as vloopup will give a numerical value !

add a sheet put each merchandise code in each row going down the column worksheet.

in the next row put the name beside the matching code.

then when finished sort on both columns using the merc, code to sort ascending.

notice in the next picture the addition of $ in the row

this is done to allow you to copy down the formula and leave the reference array the same

look at bottom of spread sheet to see additional sheet being used called code to create the array for the look up. With more array rows just modify the formula to say =lookup(a2,codes!$a$1:$b$200)

lookup will give you a text answer where as vloopup will give a numerical value !

May 07, 2018 | The Computers & Internet

Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The process is a simple one. Read on to learn how to define a table in Excel 2007
Thanks for choosing Fixya............
Sandeep

Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.

Click on the "Insert" tab at the top of the document.

Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.

Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.

Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.

Hit the "OK" button at the bottom of the Create Table dialog box to create your table.

Mar 18, 2011 | Computers & Internet

this is how to create a table

- Click where you want to insert a table.on you work sheet
- click On the
**Insert**tab, in the**Tables**group, click**Table**, - Replace the data in the template with the data that you want.i.e the number of
**rows**and**columns**you want

Apr 28, 2010 | Microsoft Office 2003 Basic Edition...

Here is one way to do it:

1. In column A enter the name

2. In column B enter their start date in the format day-month-2008 (31-12-2008 for Dec. 31, 2008); if a day is less than 10, put zero in front (03, 04, etc.)

3. In column C put 31-12-2008 (December 31, 2008, the last day of the year)

4. In column D, put C1-B1 and format as a number with 2 places after the period (10.25 for example) if you want to track partial days, other format for no zeroes after the period (13)

5. In column E, put this formula:

(D2/30)*1.25 (assuming this is line 2)

You can then copy these lines as many times as you need to, total them, etc.

1. In column A enter the name

2. In column B enter their start date in the format day-month-2008 (31-12-2008 for Dec. 31, 2008); if a day is less than 10, put zero in front (03, 04, etc.)

3. In column C put 31-12-2008 (December 31, 2008, the last day of the year)

4. In column D, put C1-B1 and format as a number with 2 places after the period (10.25 for example) if you want to track partial days, other format for no zeroes after the period (13)

5. In column E, put this formula:

(D2/30)*1.25 (assuming this is line 2)

You can then copy these lines as many times as you need to, total them, etc.

Dec 27, 2008 | Microsoft Office Standard for PC

You probably need to organise your pricelist sheet so that you only have 2 columns, product and price. If this doesn't fix you, please provide the syntax of your vlookup code.

Dec 10, 2008 | Microsoft Excel for PC

Hi,

Cool problem I use this to track stocks for the latest 5 days, 15 days and so on.

First I have a sheet that is titled "DataRecord" this has my individual data in columns and the days recorded in rows. This is a complete record or all recorded stock activity. This is where all the entrys are made in rows. I freeze window to make the column headings and the left most column(the date) always visible to prevent errors.

Next I have a sheet that is titled "L5DaysData' I have sevreral rows of data like avg, & what ever. and the latest 5 days data starts on line say 6. a typ. cell ='DataRecord'!B970

The next cell down has a value of ='DataRecord'!B971 and so and on until B974

My Graphs are built on these individual "L5 or 15 or 60 or90 day" sheets of data.

Next I make a macro that translates the last line of data down one row and deletes the row just above the earliest that I want to save on "L5DaysData" so it always shows only the latest 5 days of information.

All the information shown on that worksheet is the data for graphs or tables refering to the latest 5 days activity.

The graphs are automatically updated with the data each time the macro is run.

You can also use a formula to adjust the date column by adding a value of one to a specfic dated cell untill you reach Sat or Sun and add 3 or 2 to that date cell and translate that down a column and use a work sheet that records only the latest 3Mo. with macros that updates the information when you want it to.

Hope this helps.

Glad to be of assistance - please rate the solution I can learn from you. Thanks

Cool problem I use this to track stocks for the latest 5 days, 15 days and so on.

First I have a sheet that is titled "DataRecord" this has my individual data in columns and the days recorded in rows. This is a complete record or all recorded stock activity. This is where all the entrys are made in rows. I freeze window to make the column headings and the left most column(the date) always visible to prevent errors.

Next I have a sheet that is titled "L5DaysData' I have sevreral rows of data like avg, & what ever. and the latest 5 days data starts on line say 6. a typ. cell ='DataRecord'!B970

The next cell down has a value of ='DataRecord'!B971 and so and on until B974

My Graphs are built on these individual "L5 or 15 or 60 or90 day" sheets of data.

Next I make a macro that translates the last line of data down one row and deletes the row just above the earliest that I want to save on "L5DaysData" so it always shows only the latest 5 days of information.

All the information shown on that worksheet is the data for graphs or tables refering to the latest 5 days activity.

The graphs are automatically updated with the data each time the macro is run.

You can also use a formula to adjust the date column by adding a value of one to a specfic dated cell untill you reach Sat or Sun and add 3 or 2 to that date cell and translate that down a column and use a work sheet that records only the latest 3Mo. with macros that updates the information when you want it to.

Hope this helps.

Glad to be of assistance - please rate the solution I can learn from you. Thanks

Oct 24, 2008 | Microsoft Office 2003 Basic Edition...

Hi,

Try using a software called MacroRunner for Excel v1.0.. you can download this from the following link

http://www.filebuzz.com/fileinfo/21205/MacroRunner_for_Excel.html

Good luck.

Try using a software called MacroRunner for Excel v1.0.. you can download this from the following link

http://www.filebuzz.com/fileinfo/21205/MacroRunner_for_Excel.html

Good luck.

Feb 05, 2008 | Computers & Internet

If you can move your name column (C) to the first column, you could leverage the VLOOKUP formula pretty easily.

To do this, do the following:

1) Move the C Column to be the A Column, shifting all other columns to the right.

2) (optional) Insert a new row at the top of the sheet (to hold the formula & seach value)

3) Use A1 as your search field.

4) In A2, enter the following formula:

=VLOOKUP($A$1,$A$2:$C$6,3,)

Describing above parameters, in the formula:

$A$1 -> the search field (name your looking for).

$A$2:$C$6 -> The table/grid you wish to search and return values from. The left most column (A) must contain the values to be searched.

3 -> is the column number (A=1,B=2,C=3, etc) within the table/grid to return.

If you cannot make the name column your first (A) column, there are more complex ways to do this. For instance, create a new sheet which redisplays the info in the structure easier for this method, and perform the VLOOKUP on that data. Other options might exist in creating a complex formula that would get you what you want.

Also, if you can sort column A (names) it would find results faster, if your data set is large.

To do this, do the following:

1) Move the C Column to be the A Column, shifting all other columns to the right.

2) (optional) Insert a new row at the top of the sheet (to hold the formula & seach value)

3) Use A1 as your search field.

4) In A2, enter the following formula:

=VLOOKUP($A$1,$A$2:$C$6,3,)

Describing above parameters, in the formula:

$A$1 -> the search field (name your looking for).

$A$2:$C$6 -> The table/grid you wish to search and return values from. The left most column (A) must contain the values to be searched.

3 -> is the column number (A=1,B=2,C=3, etc) within the table/grid to return.

If you cannot make the name column your first (A) column, there are more complex ways to do this. For instance, create a new sheet which redisplays the info in the structure easier for this method, and perform the VLOOKUP on that data. Other options might exist in creating a complex formula that would get you what you want.

Also, if you can sort column A (names) it would find results faster, if your data set is large.

Feb 03, 2008 | Microsoft Excel for PC

Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.

Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data

Select the entire data and do an auto filter

In column F filter the data by Duplicate and delete all these rows

What remains should be unique data

Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data

Select the entire data and do an auto filter

In column F filter the data by Duplicate and delete all these rows

What remains should be unique data

Dec 19, 2007 | Computers & Internet

at first select the 1st page data and select data-subtotal from the upper menu list.

then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

Dec 04, 2007 | Microsoft Excel for PC

Sep 26, 2018 | ZTE Computers & Internet

Sep 26, 2018 | Computers & Internet

114 people viewed this question

Usually answered in minutes!

i want to create a contact sheet with 6 frames bt the margins betweent each frame is too large. How can I increase the size of pictures and reduce the margin gap.

×