Placing A Small Vertical Line On The Paper

Dec 9, 2008

I am currently using a sheet of paper and tallying events. By tallying, I mean placing a small vertical line on the paper, then after 4 vertical lines, I place a diagonal line across the four. At the end of the month, I add all these up. I would like to make a spreadsheet to replace the tallying, but am not sure how to do it. Is this possible? I am beginner to intermediate with Excel and use 2003, but can switch to 2007.

View 3 Replies


Print The Worksheet On Different Paper Which Requires To Go Into The Properties And Change The Paper Source From Automatically Select To Manual Feed

Jun 30, 2006

When I hit the print button the worksheet prints on the paper in the bin. However, there are times when I need to print the worksheet on different paper which requires me to go into the properties and change the paper source from Automatically Select to Manual Feed. I have been trying to created a macro what will switch to Manual Feed, print the worksheet and then switch back to Automatically Select but have been unsucessfull.

View 3 Replies View Related

Replace Small Square Character With Line Break After Import

Nov 18, 2008

When importing text from a CSV, the 'line returns' appear in a cell as a small square with faded left and right sides. The do force a line break as intended. However, they are a nuisance in reading and printing.

When I use ALT+ENTER to force a line break, there is no visible character (on screen or printed) for the line break, which is as it should be.

How can I replace this 'special character' line break with one not visible?

View 9 Replies View Related

Remove Vertical Line Character

Mar 26, 2007

How do I search for and remove the vertical lines in the above example from the column D? These things came when I imported a data file into Excel....

View 9 Replies View Related

How To Built Vertical Line Chart

Dec 2, 2009

I want to show values on the X axis, and show data/name/legend on the Y axis, then the line chart is vertical, not horizontal..

View 9 Replies View Related

Add Vertical Line To 2 Graphs With Scale X Axis At Same Time

Sep 16, 2012

Two graphs with different scale x-axis.

Graph No. 1 with smaller time frame, Daily.
Graph No. 2 with larger time frame, Weekly.
Objective: Add vertical line to mark the same times in both graphs.

Trouble is both graph already utilise the secondary axis. VBA is allowed.

View 6 Replies View Related

Move Data From Vertical Column To Line Up Horizontally

May 20, 2008

How do I move data that is in a vertical column to line up horizontally (in separate columns, but same row)? For example, take an address:


How do I get it to go from that format to this format?

Name Address City/St Zip

View 9 Replies View Related

Stock Chart - Create Multiple Short Vertical Line?

Jan 5, 2014

I have created three lines between two point.

But if the two point is located at the same horizontal line.

The line cant be produced.


View 10 Replies View Related

Add Dynamically Vertical Line To Chart Without User Intervention After Initial Setup Of Workbook?

Mar 21, 2014

I am trying to add a vertical line dynamically to a chart. What I mean is I have a chart that will have a line type chart on it and I want to add a vertical line to it based on the output of one cell in that same workbook. I am making this workbook for use by end-users so I can't ask the end-users to make a bunch of modifications to the sheet or or chart. What I do has to just work when they use the workbook.

The line chart has an X axis of time and a Y axis of items sorted. (This is the part of the chart I have done already.) I want to add a vertical line fed from a cell which will have a time fed from a cell on the workbook. For example the line chart goes from 9:00 to 16:00 and the vertical line might be at 13:00. The cell feeding the vertical line is subject to change based on the other inputs on the workbook so that's why I say the vertical line has to be dynamic as the vertical line could be anywhere between 9:00 to 16:00 or it might even be that I can't place the vertical line because the feeding cell is outside the range of 9:00 to 16:00.

I have seen a number of ways to do this but none that are dynamic and automatic and don't require end user to adjust the workbook to make the vertical line at the correct on the time scale.

View 2 Replies View Related

Printing Spreadsheet On 11 X 17 Paper?

May 7, 2004

how to choose 11 x 17 paper as my paper size option. They don't want it on anything but this size.

View 8 Replies View Related

Worksheet As Graph Paper

Aug 8, 2007

Is there an easy way to format cells so that they are square like graph paper?

View 2 Replies View Related

How To Make Worksheet Cover All Of Paper

Jan 17, 2013

CK Nursery and Finish Inventories.xlsxAttachment 207447

I would like the "Finish Summary by Age" tab worksheet to look like the "Nursery Master Sheet" and "Circle K 1 - CD Farms Nursery" tab worksheets. I'd like the "Finish Summary by Age" tab worksheet to cover the majority of the paper like worksheets on the other tabs.

View 1 Replies View Related

Serial Numbers Printing On Each Paper

Jan 11, 2013

I have one page in excel to print. But I want to print it 1000 times and on each paper i need another serial number. How do I do this?

View 4 Replies View Related

Print On Paper A Formula That Is In One Cell

Mar 19, 2007

How do you print on paper a formula that is in one cell?

View 9 Replies View Related

Formula For Defining Paper Sizes

Jul 31, 2007

I have 2 colums that represent the height and width of a paper edges. And now I would like to find a formula (somekind of an IF?) which would calculate automatically (taking account the values in these colums) which of these 2 measures make together ISO paper sizes A0 (84,1x118,9), A1 (59,4x84,1), A2 (42,0x59,4), A3 (29,7x42).

View 2 Replies View Related

2 Input Vertical Ranges Need Formulas To Output 2 Vertical Summary Ranges

Mar 7, 2013

I have two vertical ranges that I need summarized into 2 adjacent vertical ranges.

model qty| modelqty
1 4.12922.0000| 4.12952.2000
2 2.000012.1250| 2.000025.1250
3 4.12929.0000| 318.0000
4 318.0000|
5 4.1291.2000|
6 213.0000|

A1:A6 is my SKU's model number B1:B6 is my inventory C1:C6 should contain formulas that result in a summary of the models D1:D6 should contain formulas that result in a sum of the inventory count for each model

View 1 Replies View Related

Bar Graph With Values On Left Vertical Axis And Percentages On Right Vertical Axis

Jan 19, 2012

how do you create a graph with a field such as vendors on the X-axis, but with dollar values spent on the left side of the y-axis and percentage of total dollars spent on the right side vertical axis?

View 3 Replies View Related

Excel 2007 :: Ignores Paper Source Selection

Nov 28, 2012

Pretty straightforward: randomly and infrequently, Excel ignores my selection of the rear tray paper source on my MX870 Canon. Able to correct issue only by closing out and re-opening Excel.

View 1 Replies View Related

Automatically Print Each Individual Row On A Single Sheet Of Paper 2003

Aug 5, 2009

I got a workbook with one active sheet. There are 6 colums and 55 rows. I want to creat a macro or formula to automatically print each individual row on a single sheet of paper. i will only need the line with a specific value printed i.e only print value more then 5

View 9 Replies View Related

Excel 2007 :: Printing Data From Cell In Desired Place On Paper?

Jan 6, 2013

I hold some data in the Excel 2007 file. It's about 400 rows and about 10 columns. On occasion I have to print some values from this file. But it has to be in defined position on the paper. It is like I already have the prepared paper with fields, and I just have to fill some fields on the paper with data from the columns. Is it possible to make a program that will take each row that I label for printing, and print just some columns but in a defined position on the paper ?

View 5 Replies View Related

Placing Button In Certain Row (VBA)

Oct 22, 2013

What is the easiest way to have a button added into a certain cell? Basically I have my workbook enter columns into a certain sheet. When a column is added into that sheet, I want to also add a button, that gives the option to delete the column that it is sitting in. I tried to record macros to figure it out, but I didnt have any luck figuring out logic behind the button placement.

View 7 Replies View Related

Placing Value On Bottom 3 Scores

Mar 3, 2014

I am trying to do the following:

901 > 0 pts
851 - 900 gets 1 pts
LOWEST 3 scores gets 2 pts

Example of what i have for the top three

I have tried to change it but cant get it to work for the bottom 3 scores.

View 1 Replies View Related

Placing A Calculated Value Into A Cell

Jan 7, 2010

if its possible to place a value (the product of a formula) into a cell ie:

Cell A1 = "a"
Cell A2 = "b"

I would like to be able to say: If A1="a" and A2="b", then place "Yes" into D1.

I realize that =if(and(a1="a",a2="b"),"Yes",0)

placed in D1 would give the same result, but I do not want to have a formula in D1, I simply want the characters "Yes" placed in there.

View 3 Replies View Related

Identify Every Weekend By Placing 'X'

Jan 8, 2010

If I have 1 Jan thru 31 Dec in A1 - A365, is there a way I can identify every weekend by placing 'X' in Col B alongside every occurrence of Saturday and Sunday?

View 2 Replies View Related

Placing Textbox Above Y Axis

Jul 23, 2014

Is there any way that I can place a text as fixed position over the highest value on the Y axes in a chart with VBA?

View 6 Replies View Related

Button Placing In Cell

Feb 1, 2014

Is it possible to place a control button on a cell?

View 1 Replies View Related

Placing A Chart On A Userform

Oct 18, 2007

I was wondering if someone could give me some sample code on how I can get a chart to appear on a userform. What I have is a userform that allows the users to change the inputs that are used in preparing the chart. Then I want a second userform to display the new chart.

I searched the posts and saw reference to saving it as a picture but I am not sure how to go about this. Can I save it as a picture within the excel file? Or does it have to be external. If so, how is this done. And can I do it without interupting what the user is doing on the forms.

View 7 Replies View Related

Macro - Placing Data In Next Row

Mar 14, 2012

I have an excel file which I run every week. I am capturing the data from my last run onto a separate worksheet. I have a total of 5 columns.

Here's an example:

Date RunNumberValidNot ValidPending 3/2/20122723133/9/201224 0024

I want to leave the data already there static and move my formula to the next row when I run my macro. How can I do this?

View 1 Replies View Related

Placing User Form

Apr 6, 2007

I have created a user form (thanks Datsmart), and now need to place the data that will be inserted in that userfom onto my spreadsheet.

The spreadsheet will have 50 rows, each containing a different project. There will be a button on each row to activate the user form for that specific row. They click the button on the spreadsheet, and the user form opens. They enter the data on the user form, and once they click the "add comment" button on the user form, the data should be entered in the last cell of the row on which the button is located.

Now the complicated part:

The users will use that for to update the project from week to week, but each week's comment needs to go in the same cell, but above the previous comment.


Week 1

Jan 1: Project lauched

Week 2

Jan 6: Project budget submitted
Jan 1: Project lauched

Week 3

Jan 22: Budget approved
Jan 6: Project budget submitted
Jan 1: Project lauched

The date being the date from the user form, and the comment being the comment from the user form. If the latest date can be bolded that would be a bonus.

They each have to go in the same cell cause all relate to the same project. This same thing will be repeated 50 times for each different project.

View 9 Replies View Related

Assigning Points For Placing

Sep 1, 2007

i have a spred sheet that i am trying to give them scores from highest 10 down to 6 then anyone under will get 5

However if there is a tie for first they will each get 10 then the next will only get 8


a1 b2( this would be there score

3.45 10
3.45 10
3.40 8
3.20 7
2 6
1.99 5
1.89 5
1.5 5
1 5

View 9 Replies View Related

Copyrights 2005-15, All rights reserved