layout

  1. J

    Sending a workbook in Page Layout

    hey everyone, i need some help. I have finalized my workbook, each tab has one page per sheet in the workbook, i want to send this to my team however I want them to view these sheets as page layout view. my problem is i only want the active sheet in each tab and i can't get rid of any...
  2. E

    Coverting layout of spreadsheet

    Hi there, I am completely new to excel and I was unaware of the extent of its functions. I have been tasked with converting the layout of a cinema timetable that is in a spreadsheet. the timetable also includes the age rating of the movie and the director . I am also not going to include certain...
  3. K

    Require changed of formulas as per new layout

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Columns C:P, I got data, in the column Q have got a index formula, and in the columns S, T & U have count of 1's, X's and 2's as shown in the example sheet1 below... </SPAN></SPAN> Current Formulas</SPAN></SPAN> <b></b><table...
  4. M

    Page Layout not working in Excel 2016

    I have Office 365, using Excel 2016. Page Layout is greyed-out. I rebooted, opened Excel, clicked on the Page Layout icon, and got a message saying "current printer not available". Does anyone have a solution?
  5. R

    VBA question

    Hi All I am using this code and the target range represents 1 layout of 72 cells. I need to include 23 more layouts. My question: should I cram it all in 1 target range or should I duplicate this code for each layout? If Not Intersect(Target...
  6. B

    VBA for Word document

    I understand this is an Excel forum, but I just came across something related to what I'm trying to do in Word through Google on this forum, and I'm hoping people continue to be extremely helpful here. This forum has been a life force for me in completing projects. I am trying to craft a VBA...
  7. B

    Add the last row

    Hi I have a sheet I want to be able to look for the last record or last row of data and paste new records from another sheet The layout for both sheets are the same, just not sue about the lastrow function
  8. N

    Table Layout to create chart for three sets of criteria

    I'm trying to figure out how how to layout the table that needs to contain three different sets of criteria so a comparison chart can be created. The chart needs to be a pilot chart so it can be manipulated to show which week is being reviewed (this would be the horizontal chart Axis) for the...
  9. G

    Consolidation of columns

    Hi, I want formula to bring sets of four columns into one set of long columns. I have 1000+ columns vertically located so want to bring in one series. Please assist. Current layout a b c d e f g h I j k l a b c d e f g h I j k l a b c d e f g h I j k l a b c d e f g h I j k l Desired layout...
  10. D

    Really stuck on using VB to sort Raw data in standard layout

    Hi, Im really stuck and getting nowhere fast, mainly because I dont know VB. Im pretty good when it comes to excel formulas, but it looks like what I am tring to do will only work through VB, and it isnt a really complicated issue either, just I have no idea what I am doing when it comes to...
  11. C

    Excel 2019: Why is my Chart Tools Layout Tab Missing?

    Simple question: Why is my Chart Tools Layout Tab missing? I want to add high-low bars to my chart. I read around to find out how and I find I should click anywhere on the chart and the Chart Tools thing will pop up with three choices under it: Design, Layout, and Format, and I should choose...
  12. A

    Adjusting the layout of disparate data in excel

    Not sure if that title is the snappiest way to label this query. I have results from a questionnaire which are partly about jurisdictions of interest of businesses. As shown (poorly) below, they way they have been pulled in to excel makes it quite difficult to interact with them. The businesses...
  13. V

    Copying information to one spreadsheet

    Hello, I need help with a spreadsheet form, at my workplace I have Certificate to be filled in, so far manually:(, using other spreadsheet with information(Data Sheet). Both are forms not tables so there are lots of merged cells in them and have different layout, and I would like to make...
  14. A

    Page Layout

    Hi guys, Someone (who is defo not me) has managed to resize every column on every single sheet in the workbook i took an age to build. Is there a way I can copy a master layout to the all of the sheets without effecting the data that is already on each sheet? massively great full for any help!
  15. hrayani

    How to post excel sheet using HTML maker

    Hello Friends, can anyone please tell me how to post my worksheet into the thread which will help me to post a layout of my data in a much better way. Regards,
  16. J

    Checking column headers on data extract - is there a better way

    I receive a number of data files each month from a number of different sources, and while they are all supposed to be in a standard layout (column headers and column order), they often aren't. I've written some code that checks to see if the values on the sheet match to either... - the...
  17. A

    Duplicate Page Setup

    Hi everyone! I have a spreadsheet with tabs for each month with the purpose of logging sales information. I created the entire spreadsheet as a group and every tab was set up in the "Page Layout" view and I had three separate pages ready to go on each tab. Somehow I must have clicked...
  18. R

    Excel page layout changed after reopening (does no longer fit on the page)

    Dear all, I have created a very extensive document for invoicing, with many tabs. I have been using this document for a long time without any issues. However, I just opened the document and the information does no longer fit on the page (e.g. logo partly displayed on the next page). Does one...
  19. P

    Copying data based on header value

    Hi Excel Master, Every month, I'm require to generate a report. I export the data from a source, put in my excel file and have to arrange the column to meet my layout . My report has a fix layout whereby the column header is fixed (e.g A1 - Name, B1 - Address, etc). The source header text is...
  20. J

    Macro to copy data from one layout to another layout

    Can anyone help with this please, I am trying to write some VBA to copy the following data in my spreadsheet to move to this format. Starting layout: <b>Excel 2012</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse...

Some videos you may like

This Week's Hot Topics

Top