Removing Extra Sheets In Page Layout View
Nov 29, 2012
I have an excel spreadsheet I have created as a printable form. It all fits nicely onto one page. I would like to be able to email it to people and have it look like a one-page form. It looks great in Page Layout view, but the only problem is that there are a bunch of extra sheets that show up as well. Is there any way to remove/hide these extra sheets that are not needed? Or is there another way to send this out so that it comes to folks as a one-page form so that they can alter the data in the cells but not the page formatting?
View 1 Replies
ADVERTISEMENT
Feb 15, 2009
I'm making a sign in and sign out sheet for work and when I go to view and then page layout I get not only that but other sheets without the texts. Also, when I go back to my normal view I see dotted lines that show the page size over and over again. Any idea how I can see only what I want to see on page layout and get rid of those dotted lines?
View 11 Replies
View Related
Jan 14, 2007
I may be a bit thick here but i am trying to change between portrait and lanscape on the same worksheet on printing. I have a very good diary planning spreadsheet set up and I am keeping all the supporting evidence in the same workbook but on different worksheets. Now i have areally silly problem. One of the worksheets holds a list or translations i need to input into a system in the office and it is 5 pages long when printing.
I want the first 4 pages to print in portrait but the last one in landscape buit cant think how to do it. I know it is easy over worksheets but i want all this info on one worksheet.
View 2 Replies
View Related
Feb 26, 2010
I need to add a footer to a worksheet.
I did it with the recorder, but its gives me WAY more than I need to know. But I cannot find in the macro, where EXACTLY, the footer is located.
[face=Courier New] With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
.LeftMargin = Application.InchesToPoints(0.7)
.RightMargin = Application.InchesToPoints(0.7)
.TopMargin = Application.InchesToPoints(0.75)
.BottomMargin = Application.InchesToPoints(0.75)
.HeaderMargin = Application.InchesToPoints(0.3)
.FooterMargin = Application.InchesToPoints(0.3)
.Zoom = 84
View 9 Replies
View Related
Jul 22, 2014
I have an Excel 2013 address book that has extra spaces between first names, last names and middle initials all in 1 cell.
Is there an easy way to remove all the spaces between these components?
View 3 Replies
View Related
Aug 1, 2012
I have a sheet in an excel workbook which I export to a separate file and then save as a text document, I need to remove the tabs in this file, however the file (example attached) needs to be in a certain format to be imported into a piece of equipment which has a proprietary file format. Part of this format is the 2nd row and 5th row must remain present and empty.
[URL]
View 4 Replies
View Related
Mar 3, 2014
Is there a way to change the page view without activating the sheet? I would like to loop through a bunch of sheets and change the page view.
I currently am aware of the ActiveWindow.View command, but this requires me to first activate the sheet. Is there a similar Sheet.View command, or something like that?
View 3 Replies
View Related
Feb 11, 2013
I lost the formatting in a 6 page spreadsheet. It repeated the top row, much as a header. I constantly delete and add rows, so it was nice to have the row in place as I scroll. It was better than freeze pane.
View 2 Replies
View Related
Oct 24, 2008
I’ve created a worksheet containing many drop down lists that form an inventory of household effects. Once selected, I’d like to be able to view/print the selected options and quantities separately on one A4 page.
I don’t want the separately viewed/ printed page to contain anything other than the selected options. The problem I’m having is to arrange this new page as a contiguous list.
View 2 Replies
View Related
Aug 5, 2014
I printed my graph after editing it while in normal view. It did not appear on paper like it looked on the screen. I switched to page break preview to see if I could see the problem and noticed that the printed version matched the page break version. I am using text boxes for some of my data on the graph itself, and the boxes, moreso than the bars, appear differently between views. This has never happened before, and I print this graph every month after changing the parameters and data. To my knowledge, I did not change anything out of the ordinary.
View 2 Replies
View Related
Apr 6, 2010
I'm working with a very large spreadsheet which has somehow divided itself into print areas. Each section has 'Page 1' or the equivalent as a background, behind the data itself. I thought it would be simple to remove this, but for the life of me I can't see how. I'm using Excel 2007.
View 6 Replies
View Related
Nov 7, 2012
I have headings across the sheet "Inventory" in cells E5:AA5 with further headings down the sheet D6:D40.Data Validation drop down list is in cells E6:AA40.I want to be able to place a number 1 or number 2 in any cell in the range C6:C40 in the "inventory" sheet and with a macro create 2 new sheets.Sheet 1 will contain all the headings which had a 1 in any of the cells in the range C6:C40 and sheet 2 will have all the headings which had the number 2 from the range C6:40.Both sheets 1 & 2 will contain all the headings from "Inventory" sheet in cells E5:AA5.The data validation drop down list is not required in sheets 1 and 2 but if "inventory" sheet does get updated that it also updates sheet 1 and sheet 2.... Version i am using is Excel 2010
View 1 Replies
View Related
Aug 11, 2008
I am using some protected workbooks and cannot see the tabs at the bottom of the screen.
I have tried going to tools/options/etc
I have tried viewing full screen
If I copy the current sheet 1 and paste it into a new workbook I can then see tabs (but only sheet 1 has copied data).
View 14 Replies
View Related
Dec 4, 2006
how can i see hidden sheets in a workbook?
View 3 Replies
View Related
Dec 22, 2009
I have an excel document with about 7 worksheets in it. The users of these worksheets can save the document but they never save it with the page view starting from the top. How can i ensure that whenever this document is open the default view for all the contained worksheets is at the top (ie:cell a1).
View 2 Replies
View Related
Jun 11, 2007
Remember Lotus used to do this?
I have on one sheet - 600 rows of financial products by 100 regions worth of $ balances and on another identically formatted sheet the associated interest rates.
I just want to page down on the $balances tab and have interest rates tab move in sync - letting me eyeball the related info.
I've tried searching for an hour to come up with the right terms - split, freeze, etc.
View 9 Replies
View Related
Nov 29, 2007
I have a workbook with 3 spreadsheets. When I put ptotection on 2 of the sheets, the custom view will not work on the other. Any way to make the views work?
View 5 Replies
View Related
Oct 11, 2007
I have a spreadsheet which is used for STAT purposes at work, there are 14 users who use this spreadsheet.
The sheets are named after a user, i.e my sheet is under 'Steve'.
The problem I have is, I have a sheet thats unhidden on the spreadsheet (the rest are all hidden)
What i want is a form to open and request a username and password, or to gain the user name from there windows logon.
After the spreadsheet has recoginsed whom is entering the sheet, i want the spreadsheet to display there individual sheet, and keep everyone elses hidden.
I don't want them to have access to any sheet other than there own.
I then want an administrator logon, where that person can see all sheets.
View 9 Replies
View Related
Mar 13, 2008
I have a workbook which, on opening, shows a logon form and depending on the username and password entered only certain sheets open - there are about 10 usernames and passwords - i have only included 2 to keep the code a bit shorter. I got the code below from here and it works perfectly but I want to make it a bit easier to add new usernames and passwords and am thinking of using a Vlookup table. The code i currently use is:
Option Explicit
Const sName1 As String = "Lisa"
Const sName2 As String = "Philip"
Const sPw1 As String = "update"
Dim sPW As String, sUser As String
Dim sMsg As String, sTitle As String, sStyle As String
Dim iCounta As Integer
Private Sub cmbValidate_Click()
sTitle = "Incorrect Password"...........
View 5 Replies
View Related
Feb 18, 2014
I have a workbook that is setup with headers and footers. To the right, left, and below the worksheet there are other pages greyed out pages that are not being used. Is there a way to change the view and potentially remove these "other sheets?"
View 3 Replies
View Related
Feb 24, 2014
What i am trying to do: Create a login option to filter what worksheets each user can see. I need the users to be able to view 2 sheets not just 1. Also i need an admin login that can view all sheets. I want to keep the workbook protected so even though they can see and edit those two sheets they can only edit certain unlocked cells. Admin should be able to view/edit all cells on all sheets.
Below is my code which is made for a sample workbook. I was just trying to get the concept down and then i would convert it to the real workbook.
Form Code:
[Code].....
View 2 Replies
View Related
Oct 3, 2008
I have written a short piece of code based on some other posts and for some reason it doesn't work and it's driving me mad. The task seems to be very easy - I'm trying to get rid of some formulas in all worksheets and keep the actual values only. The part that is failing is the following: ws.Range("A1:P31").Select
View 8 Replies
View Related
Jun 9, 2009
When I view a sheet under Page Break Preview, it shows the Page numbers in the centre of the Page. While I am aware that it would not print the page number I was wondering if there is an option to remove/hide the page numbers.
View 3 Replies
View Related
Jan 27, 2010
I have an 6 sheet excel workbook that generates 27 additional sheets upon an executed macro. I am trying to page setup the additonal 27 sheets only to a zoom of 90. Here is what I have so far but this zooms all 33 sheets.
HTML Sub zoom_2()
Application.ScreenUpdating = False
Dim wk As Worksheet
For Each wk In ThisWorkbook.Worksheets
wk.Activate
With ActiveSheet.PageSetup
.zoom = 90 End With
Range("A1").Select
Next wk
Sheets("data").Activate
End Sub
View 2 Replies
View Related
Jun 12, 2014
I've been using excel sheets to create reports for clients based on various sized samples of bars (I'm a test engineer). The sheets are essentially the same format though information will vary (such as bar type, diameter, etc.) I've been working on automating these sheets so that I don't need so many template-like tabs (currently I have a workbook for each client setup with 5-20 different sheets just in case the client sends in those bars! Half of the sheets stay blank and it can be confusing/cluttered).
Here's what I want to do: Have one page or popup window where I can input the information (job number, bar size, bar type, etc.) press the magic button and have it spit out a new sheet with that info added into the template. Is this doable?? I've never used macros before but I'm assuming I'll need to, which is fine, how that works.
View 4 Replies
View Related
Aug 29, 2009
For each of the sheets below, I need to extend the bottom of the page down ten rows and i need a page break after 60 rows.
Does anybody have any ideas? Here are the tabs that I need this macro on:
(MySheets = Array("FY09 Installation Support", "FY09 Install", "FY09 Purchase", "FY09 CF Discretionary Grants", "FY09 CF LOI", "FY08 Purchase", "FY08 Installation Support", "FY08 CF Discretionary Grants", "FY07 Sup Install Support", "FY07 CF Install Non-LOI", "FY07 Sup Purchase", "FY05 CF Carryover Install", "FY04 Recovery Funds", "FY05 Recovery Funds", "FY08 Safety Carryover", "FY09 Safety", "FY09 Transport Canada")
View 9 Replies
View Related
May 4, 2007
I have data in two sheets. None of the sheets the rows and columns are fixed.
I want to copy the data from the two sheets and paste it in the third sheet. I have attached a sample sheet for reference. I need to set it in page width so that I can print that.
View 3 Replies
View Related
Aug 21, 2007
I am trying to find a way to print an "entire workbook", but have each of the sheets paged as a group separate from the rest. One workbook typically has up to 20 sheets, with each sheet up to roughly 8 pages. I need each sheet set to show page 1 of 8 or page 5 of 8, not page 22 of 53. Counting and typing in the total number of pages in each sheet's footer is too cumbersome. Also, printing each sheet individually has also been cumbersome when printing to PDF. Are there any other ways to have the "&[Pages]" function only reflect the number of pages within the sheet instead of in the entire workbook?
View 9 Replies
View Related
Dec 12, 2013
Excel 2007 - need to adjust protected view settings but the protected view tab is missing from my Trust Centre settings - have the following tabs - trusted publisher / location, add-ins, activeX, macro, message bar, external content and privacy options. Document is a revenue authority download and without being able to adjust the protected view settings, can't input data.
View 3 Replies
View Related
May 18, 2006
I have some code that parses an html table. I want to put in error handling in case the format of the page changes or the internet page is unavailable. I am testing without an internet connection and the run time error is not being branched off to the error handler and is fatally ending the macro. This is true also if I raise an error manually.
Private Sub ParseInjuryPage()
On Error Goto ErrorHandl
Dim strPage As String
Dim webIE As SHDocVw.InternetExplorer
Dim myURL As String
Dim tableBeg As Long
Dim tableEnd As Long
Dim RowBeg As Long
Dim rowEnd As Long
Dim cellBeg As Long
Dim cellEnd As Long
Dim strBeg As Long
Dim strEnd As Long
Dim myCell As Range
Dim rowNum As Integer
With Sheets("INJ")
Set myCell = .Range("A2")
.Range("A:F").Value = vbNullString
rowNum = 2
Set webIE = New SHDocVw.InternetExplorer
myURL = "http://www.sportsline.com/nfl/injuries"
webIE.Navigate myURL
Do Until webIE.ReadyState = READYSTATE_COMPLETE
DoEvents
Loop
strPage = webIE.Document.body.innerhtml...................................
View 6 Replies
View Related
