Gtag

Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts
Admin

How to Unprotect an Excel Sheet Without Password

By  
This document will tel you how to unprotect an excel spread sheet without having the password
In case of a password protect worksheet you are unable to Edit the data on the Excel Sheet. If you do not Remember the Password or do not know the password to unprotect the sheet just follow the below simple steps.



Press ALT +  F11 or click on View Code in Developers Tabs



In the Above White Space Enter the below Code. Do not change the code just copy paste:


Sub PasswordBreaker()
    'Breaks worksheet password protection.
    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer
    Dim i4 As Integer, i5 As Integer, i6 As Integer
    On Error Resume Next
    For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
    For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
    For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
    For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
    ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
        Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
        Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    If ActiveSheet.ProtectContents = False Then
        MsgBox "One usable password is " & Chr(i) & Chr(j) & _
            Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
            Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
         Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
End Sub


Now Click on the Run Button or press F5:




And there you go the sheet is unprotected for you now. Also you would be getting a message in the pop up window.



This Message is contains the password which can be used to unprotect the other sheets in the same workbook.
Read More
Admin

Add a watermark to an Excel document

By  

A. TEXT WATERMARK:
The trick is to place a WordArt on the background of the Excel sheet. 
Microsoft Excel 97/2000/XP (2002)/2003:
  1. Open the Excel document that you want to add watermark to.
  2. Select "Insert" from the top menu, then select "Picture" > "WordArt...".
  3. In the "WordArt Gallery" dialog, select a WordArt style that you like then click "OK".
  4. In the "Edit WordArt Text" dialog, type in your desired text, select the font style and size, then click "OK".
  5. Right-click on the newly inserted WordArt on the Excel document, then select "Format WordArt...".
  6. In the "Format WordArt..." dialog, select "No fill" for "Fill"/"Color".
    Also select a brighter color (i.e. gray) for "Line"/"Color" then click "OK".
  7. Right-click on the WordArt on the Excel document, then select "Order." > "Send to Back".
  8. Click and drag the WordArt to position it where you like.
    Note: The WordArt needs to be manually placed on each page of the document.
Microsoft Excel 2007/2010:
  1. Open the Excel document that you want to add watermark to.
  2. Select the "Insert" tab from the top menu, then in the group "Text", select "WordArt".
  3. Select the WordArt style you want, then type the text for your watermark.
  4. Under "Drawing Tools", select "Format".
  5. In the group "WordArt Styles" change "Text Fill" to "No fill".
  6. Also in the same group "WordArt Styles", change "Text Outline" to "Automatic".
  7. In the group "Arrange" select "Send to Back".
  8. Click and drag the WordArt to your preferred position.
    Note: The WordArt needs to be manually placed on each page of the document.


B. IMAGE WATERMARK:
To insert an image watermark, use the header feature in Excel as follows... 
Microsoft Excel 97/2000/XP (2002)/2003:
  1. Open the Excel document that you want to add watermark to.
  2. Select "View" from the top menu, then select "Header and Footer".
  3. In the "Page Setup" dialog, click on the "Custom Header..." button in the middle of the dialog.
  4. In the "Header" dialog, click on the middle box "Center section"
  5. In the middle of this dialog box, there are some tool buttons. We're going to use the last two buttons to insert and format the image.
  6. Click on the Insert Picture button (the second-to-last button with an image of a mountain)
  7. Navigate to the folder where your watermark image is located. Select the image and click "Insert".
  8. A text "&[Picture]" is now placed in the middle box named "Center section".
  9. Click on the Format Picture button (the last, right-most button).
  10. Adjust the scale and size if you wish, then select the "Picture" tab. Change the "Color" under "Image Control" to "Washout", then click "OK".
  11. At this point, you can click "OK" to finish, and do a "Print Preview" to see your watermark. However, you will notice that the image is placed far on the top of the page, which doesn't look usual for watermarks. To fix this, click on the middle box named "Center section" again and enter a few blank lines before the text "&[Picture]".
  12. Once you're all done, click "OK" to exit and open "Print Preview" to see your watermark. (The watermark will not be displayed in normal view.)
Microsoft Excel 2007/2010:


  1. Open the Excel document that you want to add watermark to.
  2. Select the "Insert" tab from the top menu, then in the group "Text", select "Header & Footer".
  3. Excel will now switch to Page Layout view, and the cursor will be moved to the center top of the page.
  4. On the "Design" Tab, in the group "Header & Footer elements" Select "Picture".
  5. Navigate to the folder where your watermark image is located. Select the image and click "Insert".
  6. A text "&[Picture]" is now placed in the middle box of the header.
  7. To move the picture down on the page, click on the header and place the cursor before the text "&[Picture]", then hit Enter a few times.
  8. To see the watermark, either open the "Print Preview" or click on any cell of the document.
Read More
Anonymous

MS-Excel Shortcut Keys

By  
MS-Excel Shortcut Keys


F2
Edit the selected cell
F3
After a name has been created F3 will paste names
F5
Go to a specific cell. For example, C6
F7
Spell check selected text or document
F11
Create chart from selected data
Ctrl + Shift + ;
Enter the current time
Ctrl + ;
Enter the current date
Alt + Shift + F1
Insert new worksheet
Shift + F3
Open the Excel formula window
Shift + F5
Bring up search box
Ctrl + A
Select all contents of the worksheet
Ctrl + B
Bold highlighted section
Ctrl + I
Italic highlighted section
Ctrl + K
Insert link
Ctrl + U
Underline highlighted section
Ctrl + 1
Change the format of selected cells
Ctrl + 5
Strike through highlighted section
Ctrl + P
Bring up the print dialogue box to begin printing
Ctrl + Z
Undo last action
Ctrl + F3
Open Excel Name Manager
Ctrl + F9
Minimize current window
Ctrl + F10
Maximize currently selected window
Ctrl + F6
Switch between open work books or windows
Ctrl + Page up
Move between Excel work sheets in the same Excel document
Ctrl + page down
Move between Excel worksheets in the same Excel document
Ctrl + Tab
Move between two or more open Excel document
Alt + =
Create a formula to sum all of the above cells
Ctrl + ’
Insert the value of the above cell into cell currently selected
Ctrl + Shift + !
Format number in comma format
Ctrl + Shift + $
Format number in currency format
Ctrl + Shift + #
Format number in date format
Ctrl + Shift + %
Format number in percentage format
Ctrl + Shift + ^
Format number in scientific format
Ctrl + Shift + @
Format number in time format
Ctrl + Arrow key
Move to the next selection on text
Ctrl + Space
Select entire column
Shift + Space
Select entire row
Ctrl + -
Delete the selected column or row
Ctrl + shift + =
Insert a new column or row
Ctrl + Home
Move to cell A1
Ctrl + ~
Switch between showing Excel formulas or their values in cells



MS-Word Shortcut Keys
MS-Excel Shortcut Keys
MS-PowerPoint Shortcut Keys
MS-Outlook Shortcut Keys


Read More
Anonymous

Pro tip: Dismiss Excel's irksome Auto Fill Options list with these tricks

By  
Learn how to reduce the annoyance factor of Excel's Auto Fill Options list. 



  Excel can sometimes be annoying when it's trying to be helpful. Its Auto Fill Options list is a perfect example.
The Auto Fill Options list appears when you use the fill handle (Figure A). To see the options, click it (Figure B). In the case of the example below, the default action is to continue the series. (The default option and the list change, depending on the selected items.) The options are self-explanatory, and it's a useful tool.
Figure A


ExcelAutoFill_FigA_122313.JPG
 
Figure B


ExcelAutoFill_FigB_122313.JPG
 
It's annoying because you can't get rid of it, and it blocks your view of other values. Many users complain about it but, so far, there's no intuitive way to dismiss it.
The most obvious action is to use it. You would think using it would dismiss it, but it doesn't. The next most obvious choice is to press [Escape] -- nice try, but that doesn't work either. Fortunately, I've found some not-so-intuitive mouse tricks that work. You can also avoid the list or disable it.

Avoiding

A little known click trick lets you avoid the list altogether. Right-click the fill handle, and then drag the handle as you normally would to complete the desired action (Figure C); this displays a contextual shortcut list. Choosing an action from the list completes the pattern accordingly and dismisses the shortcut list. The options list never appears!
Admittedly, this process is a bit awkward at first, and you must remember it before using the fill handle. It works, but unless you employ it often, you probably won't remember it.
Figure C


ExcelAutoFill_FigC_122313.JPG
 

Disabling

You can easily disable the options list by following these steps:
  1. Click the File tab and choose Options in the left pane. In Excel 2007, click the Office button and then click Excel Options. In Excel 2003, choose Options from the Tools menu, click the Edit tab, and skip to step 3.
  2. Choose Advanced in the left pane.
  3. In the Cut, Copy, and Paste section, uncheck Show Paste Options Button When Content Is Pasted in Excel 2007 (Figure D). In Excel 2003, uncheck Show Paste Options Buttons.
  4. Click OK.
Figure D


ExcelAutoFill_FigD_122313.JPG
 
This option disables both the fill and paste lists. There's no way to disable only the auto fill list of options. If you won't miss either list, this is a possible solution.

Mouse tricks

As a rule, I don't like to disable default options; however, it seems benign to disable these two options lists.
If you don't want to disable the feature and remembering the right-click on-the-fly technique isn't working out for you, these two simple mouse-click tricks will dismiss both of these options lists.
  • Double-click any row or column header border. Don't change the row's height or width -- simply double-click the border.
  • Click Zoom Out or Zoom In (in the bottom-right corner of the screen) (Figure E).
Figure E


ExcelAutoFill_FigE_122313.JPG
 
Other actions will dismiss both lists, but these are the most convenient that I've found. Regardless of where you're working in the sheet, one should be easy to implement without annoying you even more than the lists. 

Read More
© Copyright 2015 Yasir Hasnain Lorem Ipsum is simply dummy text of the printing and typesetting industry.