## Print and page setup

I have 2 sheets. I have data in one sheet. for each file I don’t know how many rows and columns it would be.I set a formula such that the …

I have 2 sheets. I have data in one sheet. for each file I don’t know how many rows and columns it would be.I set a formula such that the …

Dear Excel Geeks My end goal is to have some code whereby a I have a list of locations in Excel. I have a macro to then run through this list and for …

MY CLIENT LEDGER TRANSACTIONS ARE MORE THEN 10 PAGES, NOW I WANT WHEN I TAKE PRINT PREVIEW OR TAKE DIRECT PRINT FROM PRINTER, I WANT TO TAKE 1ST PAGE LAST LINE …

I have an Inventory sheet that lists the past 7 days of materials. Each day has it’s own sheet and the sheet name is a date in the form 1-2-2019, …

I have a list of tenants for a single building, ranging from one tenant to up to six tenants. I am wanting to automate mail merge canned letter templates from …

Hi, I have a workbook with a lot of data. I’ve created a 2nd workbook that references the data in the first. I do this so I can share that …

ADD SUBJECT(1) FROM RANGE A1-A10 AND ALL THE (1) N THAT ROW WILL ADD FROM C1-C10 A1 C1 1 …

A B C D E F 1 Date Batch 1 1st Time batch 2 2nd Time Hour 2 28/1/19 AA103 BB100 6:09am 0.75hrs 3 28/1/19 AA104 BB101 6:15am 1.23hrs 4 …

So what I’m doing is hyperlinking my summary page items with each worksheet in the workbook. I’m getting an error in my code on the last line …

Key Word Store Name Key Word Result Pharmacy all in all grocery Grocery health pharmacy 2365 …

I have 2 columns of data. Column A contains 1000 unique files names. Column B contains 500 unique file names. I know that Column A contains all of the file …

Hello…My name is Robert, and I am an intermediate school math teacher. The following formula works for me, but I also need to a assign a value of zero …

I have two columns, one with a name and one with an item. There are sometimes multiple names for the same item and multiple names with different items. I am …

How do I set up a column to average a row of numbers? Example: Number Average 120 120 125 123 200 148 I want to make the cells in the …

I need to find the marks from the two different tables, TABLE 1 TABLE 2 NAME PHY CHEM MATHS NAME HINDI SST EVS RAJNEESH 38 66 …

I have a worksheet with all 50 states in column A, and the names of cities in those states listed in columns B through AZ. I would like to change this so …

I have an excel sheet with 1500 records. I want to insert pagewise subtotals of some columns with numerical data and print. Please help By:

Hello, I have a large table where my numbers are in the scientific notation x10^ format (I used a formula to convert the Excel E scientific notation …

Hi all, I need to calculate the rental period for a widget between a start date and an end date. This rental period has to be broken down as …

I have a column that has address line data in and I want to see how many unique addresses I have, the issue is the fields have been manually typed in so using …

Hi, I am doing a spreadsheet and I need one column (D) to go red and say “Not Ready” if any of the 7 other cells (E to K) in that row are …

I am trying to add cells from differnet sheets that are also not consecutive. So for example, I want to add AA3+AA6+AA9+AA12 from sheet 1 onto sheet 2. I have …

Helllo, I have a large report that lists 12 statements like the one below from a list of employees The numbers 1-5 are meant to indicate strongly …

I want to have the date auto fill in column G when the word “Complete” is in column F and want it to stay that date. How do i do that or can that …

Hi, I’d like to create a mapping sheet to generate a report based on internal data and the data from the client. The problem is, the products don’t …

I am trying to create a spreadsheet that will total the number of hours spent in work during each month and give me the monthly average based on the number of …

what is the formula for a 10% discount up to $4000, with a maximum discount of $400. Thanks. By:

I am setting up a workbook for tracking some video game elements for a friend. It’s set up with a couple cover sheets that pull data from 100 …

hi, the value of a number i am pasting is 10 decimals long (ex: 55.4297804839) but i got the cell to show 1 decimal (55.4) how can i change the value of …

I have a spreadsheet with hundreds of cells and formulas in a high percentage of them. Rather than transcribe each cell’s formula, is there a way …

I have a spreadsheet with hundreds of cells and formulas in a high percentage of them. Rather than transcribe each cell’s formula, is there a way …

I have a spreadsheet with hundreds of cells and formulas in a high percentage of them. Rather than transcribe each cell’s formula, is there a way …

Hi, I am looking for some support regarding the below issue. A B C D Lead Time Example Wk 36 2019 Wk 50 2020 19 If (CD + Lead Time is less …

I have a spreadsheet that needs to update the current date in (for instance) Column B1 if anything has been selected from a dropdown menu in Column C1. …

I have a spread sheet with data. Column A is date stamped for a month. Columns c-I have readings. What I need is a formula to capture the individual day in …

Hey guys, I’m looking to my Google sheet has varies columns with values inserted in the rows (62 rows). I want to insert a few rows to represent what …

I need to find out how to place a bottom border ONLY on each row of a table that is 20 columns by 1000 rows in size. How can I get this with less than 5 clicks …

I am a user of Excel for Mac, version 16.16.5. I am sorry that I have no idea of the required code in total, but I am familiar with recording macros, …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.