Fillig up excel sheet with zeros
This query is : Resolved
01 May 2009
I have a big excel worksheet where I have filled up numbers in some cells. In the cells which dont have numberes or forumulas I want to have "0"(zero). What is the short cut for this? Can this be done in one go?
Thanks.
Thanks.
01 May 2009
hi Anil,
write 0 in one cell. copy it (ctrl+C). Now select the area where you want 0 in blank cells (be sure the selection only has numbers & no text). Now paste special (Alt+E+S) select 'Add' & press enter.
Pls feel free to ask again if you have any problem doing this.
write 0 in one cell. copy it (ctrl+C). Now select the area where you want 0 in blank cells (be sure the selection only has numbers & no text). Now paste special (Alt+E+S) select 'Add' & press enter.
Pls feel free to ask again if you have any problem doing this.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Is this income indian or foreign income?
- ITC temporary reversal and reclaim
- Inventory of finished goods
- Applicable TDS rate for sale of property in Nov 2024
- RCM INVOICING FROM NOV-2024
- Sale of property furniture sale
- Can we claim ITC of Feb-2024 in the month of November-2024 which was not claimed by oversight
- Tds on building rent monthly
- Confusion around Form 26QB fields
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- TDS under section and rate of TDS
- GST input on scooter purchased
- TDS under section 194Q and TCS under section 206C
- GST input on car insurance and repairs
- GST input on Diwali gift to employee
- GST input on Mobile Handset
- Material and freight in same invoice
- TDS under section 194J inclusive of reimbursement of expenses
- TDS on Material and Labour in same invoice
- Should I be worried about and rectify reporting Jan,Feb ,March 2024 foreign salary in schedule FA?
Trending Online Classes
CAclubindia
