sponsored ads

How to make a cheque in excel?

sponsored ads

I always use excel to do my work since I entered this company..This time, my boss asks me to make a cheque in excel..I never do this before.I wonder who can give me a tutorial to tell me how to do that..Thanks very much. Asked Dec, 14 2010
add commentflag 

sponsored ads

answer this question

  • Go to Gateway of Tally > F11: Accounting Features
  • Set Enable Cheque Printing to Yes
  • Set/Alter Cheque Printing Configuration to Yes.
Answered Feb, 28 2011
vote up 1 vote down


•1.Draft your crossword puzzle with paper and pencil. Determine what size grid you will need, where you want to place your clues, and how clues will cross on the grid.

•2.Start a new, blank document in Microsoft Excel.

•3.Select a number of rows equal to one more than the vertical size of your planned grid (for example, if you need a grid 20 spaces high, select 21 rows).

•4.Right-click in cell A1, click "Row Height," and then enter "20" in the option box that appears. Click "OK."

•5.Select a number of columns equal to one more than the horizontal size of your planned grid (for example, if you need a grid 20 spaces wide, select 21 rows).

•6.Right-click in cell A1, click "Column Width," and then enter "2.5" in the option box that appears. Click "OK."

•7.Starting in cell B2, select your grid area, then click on the "Borders" button in the Font box on the Home ribbon. Select "All Borders" from the pull-down menu.

•8.Key in your answers, one letter per cell (don't worry--you will delete them later). Make sure that all answers are spelled correctly and that words cross at the appropriate letter.

•9.Select the empty cells (hold down the "Control" key and click each empty cell). In the Font box on the Home ribbon, click on the "Fill Color" button, then choose "Black, Text 1" as your color (first row, second column).

•10.Select your crossword grid and delete all the answers. Type a small (font size 6) corresponding clue number in the first cell of each answer's space.

•11.Type your numbered clues, one clue per cell, in separate cells to the right of the crossword grid.

Answered Nov, 17 2010
vote up 0 vote down

'To create a blinking cell:
'
'If you define a new Style (Format / Style / Flash/ Add ) and apply that style to the cells you want to flash, paste the following code into a module sheet and run the procedure Flash from Auto-Open if desired you will get the text flashing alternately white and red.

Dim NextTime As Date

Sub Flash()
NextTime = Now + TimeValue("00:00:01")
With ActiveWorkbook.Styles("Flash").Font
If .ColorIndex = 2 Then .ColorIndex = 3 Else .ColorIndex = 2
End With
Application.OnTime NextTime, "Flash"
End Sub

Sub StopIt()
Application.OnTime NextTime, "Flash", schedule:=False
ActiveWorkbook.Styles("Flash").Font.ColorIndex = xlAutomatic
End Sub Answered Jan, 07 2011
vote up 0 vote down

Your Answer

community wiki:

The Verified Code is to stop spamming. It will be hidden once your reputation reached 100.
or
Create one

Options

sponsored ads

Download related software from AFC

Office Excel 2007 1.0

Last Updated: Apr 2, 2011
License: Demo
Filesize: 10.17MB

Continue to downloadPower by Afreecodec.com